Re: Privilege problems

Jimmy wrote in message <34DE0269.396C_at_comp.polyu.edu.hk>...

>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?

user1->
create synonym user2.table1 for table1;
or
user2->
select * from user1.table1;
>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?
>

Best regards,
Miroslav. Received on Sun Feb 08 1998 - 00:00:00 CST