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
Post a Comment