CODEWITHSUNDEEP
sqloracle-database
spider8
spider8

Reputation: 157

Roles in oracle

I created a view in schema A using snapshots in schema B. I was trying to assign roles to the view. But it doesnt allow me to. It says there is some error related to access to the tables from the snapshots.

Any ideas?

Upvotes: 0

Views: 100

Answers (2)

Craig
Craig

Reputation: 5820

Schema B needs to grant schema A select on the snapshots "with grant option" for schema A to be able to pass on the grants to other schemas/roles.

GRANT SELECT ON my_table TO a WITH GRANT OPTION;

Upvotes: 1

Andrei Coșcodan
Andrei Coșcodan

Reputation: 717

Schema B needs to grant schema A select on the snapshots "WITH GRANT OPTION" ("WITH ADMIN OPTION" is only for system privileges, not object privileges):

grant select on TABLE_NAME to A with grant option;

Upvotes: 2

Related Questions