Re: Privilege problems

Jimmy,

Make sure that user2 prefixes tables1 with the schema name. i.e., user1.table1.

The other way you could accomplish this is by creating a public synonym for table1 as table1.

Hope this helps.

Murali Kazhipurath
(murali_at_jps.net)

Jimmy wrote in message <34DE0269.396C_at_comp.polyu.edu.hk>...
>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 Sun Feb 08 1998 - 00:00:00 CST