Database Administration (MOSC)

MOSC Banner

11gr2: grant create session results in invalid username.

edited May 16, 2018 5:03AM in Database Administration (MOSC) 1 commentAnswered

Hello,

I created a new user in oracle database,     I am trying to grant privilege , but it results in  invalid username

select username,profile,account_status from dba_users where username = 'XXXXX';

XXXXX USER_PROFILE OPEN

SQL> grant create session to 'XXXXX';

grant create session to 'XXXXX'

                        *

ERROR at line 1:

ORA-00987: missing or invalid username(s)

Please advise

Thanks

Ram

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