|
From: peng p. <pen...@gm...> - 2006-05-02 13:57:45
|
Hi, I want to create some non-DBA users but I have many tables. I think what I should do is: 1, first, create a role CREATE role regular_user 2, grant priviledge to this role. grant all on table1, table2,... to regular_user. (There is no short-cut as grant all on all (or * ) to role_name ?) 3, create user user1 password "password1" 4, grant regular_user to user1. I know there is a DBA role. Is there any other built-in role so that I can use? I just need to create some user without DBA role. Thanks a lot! Frank Peng. |