richardana
08-14-2001, 12:18 PM
Hi All,
I have a group of 3000 users that I have created.
in a table called my emp_tbl. I also created 3 roles as follows.
1)select_role ......for the 2800 users( for read only purpose.
2)select_update_delete_role (150 users)
3)insert_update_delete_role. (50 users)
These users needed to be granted CONNECT, RESOURCE privilege in order or to be connected to the database.
Questions
1)How do I go by granting all the 3000 users CONNECT, RESOURCE with one script? rather doing granting them one by one.
Now that they can be connected...
How do I go by granting appropriate role to the members of the 1st, 2nd, and 3rd role?
Can you please send me a step by step guide?
Respectfully
Richard
I have a group of 3000 users that I have created.
in a table called my emp_tbl. I also created 3 roles as follows.
1)select_role ......for the 2800 users( for read only purpose.
2)select_update_delete_role (150 users)
3)insert_update_delete_role. (50 users)
These users needed to be granted CONNECT, RESOURCE privilege in order or to be connected to the database.
Questions
1)How do I go by granting all the 3000 users CONNECT, RESOURCE with one script? rather doing granting them one by one.
Now that they can be connected...
How do I go by granting appropriate role to the members of the 1st, 2nd, and 3rd role?
Can you please send me a step by step guide?
Respectfully
Richard