Connect & Resource Privilege

[richardana]

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

[marist89]

This question is answered in http://www.dbasupport.com/forums/sho...threadid=14541