Grant Role schema all objects

[pedrovlf]

Environment information:
* Oracle version: 9i
* Operating system: Linux

Srs,

How do I do To run a Grant in a roller to be valid for all SCHEMA objects without having to specify which object, example:



] Being that * means everything that is in Schema1, how to do? thank you so much!

[Dulima-SP]

It is my shed

the way you want I do not know if you have as ....

Let's wait for the masters ...

More if I do not have a way ...

plays the parameters in a dynamic SQL ....

[pedrovlf]

Thank you ... But do not you know any other way to accomplish this? I want the user to have full access to another schema saka

[RodrigoValentim]

In Query below, you will allow permission to all objects of your user to a particular group / user.

Select all

set heading off; 
spool all.sql 
select 'GRANT ALL ON ' || object_name || ' TO [usuario / Rule];'  
   FROM user_objects; 
spool off; 
@all

You can include all_tables, all_objects, etc.

[pedrovlf]

Thank you ... more where in this query I inform the schema that will get access? or do I do this query in the schema that I want it to have access?

[pedrovlf]

I receive the following error:

Select all

ERROR at line 1: 
ORA-00903: invalid table name

[RodrigoValentim]

Post the script!

[pedrovlf]

Thank you ... I already solved ... but I would like to take another doubt ... What Grant I provide for the user to have privileged to create roles? Add privileges to roles and add users to roles?

[diegoleite]

Amiga,

http://download.oracle.com/docs/cd/B105 ... /privs.htm

I hope I have helped ...

[chavana]

Good
can help me s.f.f

I noticed that a few years ago that had to give access to a schema a Grant Select to all tables.
There is a solution to give Grants SELECT to all tables already created in the created and new schemas that are created in the BD, so then I only add this scroll to the Users that will access SELECT to all schemas.

Select all

grant select any table on "role" to "schema";

Thanks

Carlos Fernandes