Is there any easy way to give permission ?

[serkanb]

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?

 

[sem]

Try to add 'run' symbol to the end of each line:

select .....||chr(10)||'/' from users