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.
