grant - Select on anothr users connection does not work -


i have create user (except dba) in db. dba create table called emp. when new user connect db must have privilages select * emp.

so used following code. @ dba connection.

create table emp(    empid     varchar2(4),    name      varchar2(15),    designation  varchar2(10),    primary key (empid)    );  create user c##xyz; grant connect c##xyz; grant update,delete,insert,select on emp c##xyz; 

but when connect xyz , try run select * emp. says table not exsist.

so can me this..

i used oracle 12c dbms.


Comments

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

c# - how to use buttonedit in devexpress gridcontrol -

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -