I have a "USERS" table on Oracle 7 (for Sun Solaris). There is ~70 user in this table.
I have to give connect permission for these users.
I wrote a SQL command like this:
"select 'GRANT CREATE TABLE, CREATE SESSION, CREATE SEQUENCE, CREATE VIEW, CREATE
PROCEDURE TO' name from users"
and I got a script. But I couldn't run this script for all users. I can run only one 'GRANT' sql command. Is there any easy way to perform this task?
I have to give connect permission for these users.
I wrote a SQL command like this:
"select 'GRANT CREATE TABLE, CREATE SESSION, CREATE SEQUENCE, CREATE VIEW, CREATE
PROCEDURE TO' name from users"
and I got a script. But I couldn't run this script for all users. I can run only one 'GRANT' sql command. Is there any easy way to perform this task?