Loops in Scripts

[DQuinn]

Hi all,

How do you loop in scripts??

I want to grant privileges to several users. Can I use a script to loop through the users, or do I have to do it manually? I could use a role, but then we have the same problem. How do I grant a role to several users?

Thanks

[marist89]

You can use SQL generating SQL to acomplish this task. Creat a query from dba_tables and construct your grants. For example:

select 'grant select on ' || t.table_name || ' to ' || u.username || ';' 
from user_tables t, dba_users u

[DQuinn]

Thank you for your reply.