OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Grants?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grants? [message #10682]

Mon, 09 February 2004 23:16

Peter
Messages: 62
Registered: August 2000

Member

is it possible to grant a privilege to all�tables (or other objects)�within your schema??

Report message to a moderator

Re: Grants? [message #10686 is a reply to message #10682]

Tue, 10 February 2004 00:08

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I think not, but you could generate your own script to grant e.g. select to dummy_user on all your tables.

Connect as your_user and perform something like:

SQL> Set Heading off
SQL> Set Feedback off
SQL> SPOOL some_directorymyscript.sql
SQL> Select 'GRANT SELECT ON '||table_name||'  TO DUMMY_USER;'
  From user_tables;
SPOOL OFF

SQL>@some_directorymyscript.sql

Best is to verify the myscript.sql file before running to see whether it was spooled correctly.

MHE

Report message to a moderator

Re: Grants? [message #10691 is a reply to message #10686]

Tue, 10 February 2004 01:42

Peter
Messages: 62
Registered: August 2000

Member

thanks a lot

Report message to a moderator

Previous Topic:	Writing to a file in PL/SQL using UTL_FILE package
Next Topic:	Chinese collation question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:29:53 CDT 2024