PL/SQL (MOSC)

MOSC Banner

granting to a ROLE syntactically indentical to GRANT TO USER

edited Jul 14, 2015 9:23AM in PL/SQL (MOSC) 5 commentsAnswered

Our application requires to granting SELECT,INSERT,UPDATE,DELETE on about 250 tables in our schema to about 400 users.

Scenario behind it: We are migrating the database behind our application from SQLBASE (Gupta,Unify, Centura, you name it) to Oracle 11g

at a large customer's site.

The customer's Oracle administration has created our users in the Oracle database. My conversion program spits out all GRANT statements to all

users on all required tables. This is quite a lot and the admin person now is asking me whether it would be possible (she did it already)

to create a ROLE, give that ROLE the required GRANTS and then assigns that ROLE to the 400 users.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center