Privilege problems

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:
2. 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?
3. 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