Grant select permission to all objects of another schema
Hello,
we run a java/database application, which imports (not "imp" )
data from external source into the database.
For every daily import , the app create new tables,views ...
in a database schema.
e.g. "create table app_master.import_20081205 ....."
Now we have the challenge, to give some users select permissions to all objects in the "app_master" schema.
Of course we can create a role and grant the required object privileges.
But this is no solution, because I have to expand this role
every day, the import is running.
Is it possible to grant select privileges to ALL objects in another schema.
we run a java/database application, which imports (not "imp" )
data from external source into the database.
For every daily import , the app create new tables,views ...
in a database schema.
e.g. "create table app_master.import_20081205 ....."
Now we have the challenge, to give some users select permissions to all objects in the "app_master" schema.
Of course we can create a role and grant the required object privileges.
But this is no solution, because I have to expand this role
every day, the import is running.
Is it possible to grant select privileges to ALL objects in another schema.
0