Database Administration (MOSC)

MOSC Banner

grant public to a user

edited Jan 3, 2013 9:25PM in Database Administration (MOSC) 5 commentsAnswered
I have not really worked with synonyms before. Some of the synonyms in EBS system belongs to PUBLIC group. If I grant a custom user with the grant PUBLIC to customuser, what kind of privilege does this user going to have:? I don't want the customuser to be able to change any base table data. Will this PUBLIC privilege give the customuser insert, update, and delete privilege to any of the oracle base tables? Please advise. Thank you very much.

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