Re: Privilege problems

Jimmy,

1. After granting role1 to user2, user2 needs to specify the schema in which the table belongs.

ie. select * from user1.table1;

NOTE: You can use synonyms so that table names do not have to be qualified with the schema name.

2. No, the roles are not automatically granted to user1. But if user1 created the roles, then the roles are probably specifying some object privileges on user1's own objects. Therefore, granting the role to oneself is made redundant as you own the objects, you already have full objects privileges.

Regards,
Mick

Jimmy wrote:

> Hello all,
>
> I have two problems about the privilege.
>
> 1) Table1 was created by user1. User1 wants user2 can do select on that table and he types the
> following commands:
> i) create role role1
> ii) grant select on table1 to role1
> iii) grant role1 to user2
> But user2 still cannot do select on table1. Could anyone tells me what's wrong?
>
> 2) When user1 creates role "A" and "B", are the roles "A" and "B" automatically granted to user1?
> If user1 wants role "A" only, does he need to revoke role "B" from him?
>
> Thanks,
> Jimmy
Received on Mon Feb 09 1998 - 00:00:00 CST