Database Administration (MOSC)

MOSC Banner

User privileges question

edited Apr 1, 2013 10:29AM in Database Administration (MOSC) 13 commentsAnswered
I am creating a user that needs to have SELECT, INSERT, and UPDATE privileges on the objects in its schema.

After creating a user I granted the user CONNECT only:

GRANT CONNECT TO usr1;

I know that connect includes CREATE SESSION privilege so looks like i do not need anything else. Am I right? Will usr1 be able to have SELECT, INSERT, and UPDATE privileges by default or do I need to grant any other roles or privileges for that?

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