oracle - Unable to Grant session to a user -


i used yesterday sqlplus on ubuntu 14.04lts today when open connect system :

sql> connect system enter password :  connected. 

then want connect account created yesterday :

sql> connect slim/slimhmidi; connected. 

when want create session had error:

sql> grant session slim; grant session slim       * error @ line 1: ora-01919: role ' session ' not exist 

i tried create session no vain:

sql> grant create session slim; grant create session slim * error @ line 1:  ora-01031: insufficient privileges 

also have error :

sql> grant connect slim; grant connect slim       * 

error @ line 1: ora-01932: admin option not granted role ' connect' didn't have these problems yesterday.

ora-01919: role ' session ' not exist

you trying grant privilege user slim while connected slim. so, grantor , grantee same here.

ora-01932: admin option not granted role ' connect

as said, connected user slim, means user has connect privilege.

to grant create session user, sys user or other user has privilege grant.

see link documentation http://docs.oracle.com/cd/b19306_01/network.102/b14266/admusers.htm#dbseg10000

update per op's comments

to give select privilege on table user:

grant select on table_name slim; 

Comments

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

angularjs - Showing an empty as first option in select tag -

php - Cloud9 cloud IDE and CakePHP -