CODEWITHSUNDEEP
sqloracle-databasesql-grant
Denys
Denys

Reputation: 4557

How to make a role from schema A "grantable" in schema B

There are two schemas in the same database: A and B. Schema A has a role A_ROLE. I want to be able to give grants to A_ROLE from schema B ( so that the users with A_ROLE were able to query tables from schema B)

Is it possible? If so, how does one do it?

Upvotes: 0

Views: 2077

Answers (1)

Guneli
Guneli

Reputation: 1721

As far as I know, in Oracle the role is a non-schema object, so a schema can not own a role.

But if you mean that User A has a role A_ROLE and want give it grants to the objects from the schema B, then you can use the following statement as an example:

GRANT SELECT ON B.table1 TO A_ROLE;

Upvotes: 1

Related Questions