| grants and synonyms [message #223918] |
Mon, 12 March 2007 04:53  |
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
|
Member |
|
|
Hello,
One of my clients asked to create a user that has SELECT grant on a specific schema.
I used following SQL to create the scripts to do this:
select 'grant SELECT on ' || owner || '.' || object_name || ' TO ISOR_SELECT;'
from dba_objects
where owner='RRGS11' and object_type in ('TABLE','VIEW','SEQUENCE');
select 'create synonym isor_reader.' || object_name || ' for ' || owner || '.' || object_name||';'
from dba_objects
where='ISOR_OWNER' and object_type in ('TABLE','VIEW','SEQUENCE');
I saw grants and synonym create statements are also produced by this script for object in oracles recycle.bin, they failed because of invalid names but I'm just wondering: should i create the grants and synomyns to the recycle.bin in this case.....what would be 'normal'?
regards,
Martin
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
