权限的问题

Question

这个问题是这样的你只要将用户B的权限更改一下给他的权限是:connect,recovery_catalog_owner
给他resource权限不行的

Answer 1

我根据你的步骤做但是没有错啊。
create synonym s_emp for emp；connect system/manager@chencreate user username identified by password;grant connect,resource to username;grant select on s_emp to username;select * from s_emp;ok!

Answer 2

我用system用户，执行grant select on s_emp to username;都报权限不足

Answer 3

用A用户登入
grant select on tab1 to b;
用b用户登入
CREATE  SYNONYM syn1 FOR a.tabl1;是不是这样做的?

Answer 4

SQL> desc common_n;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 G3E_CNO                                            NUMBER(5)
 G3E_CID                                            NUMBER(5)
 G3E_ID                                             NUMBER(10)
 JOB_PLACE_NAME                                     VARCHAR2(30)
 JOB_PLACE_DATE                                     DATE
 INSTALL_DATE                                       DATE
 ABANDON_DATE                                       DATE
 JOB_MODIFY_NAME                                    VARCHAR2(30)
 JOB_MODIFY_DATE                                    DATE
 OWNER1_ID                                          NUMBER(10)
 OWNER2_ID                                          NUMBER(10)
 GPS_X_COORD                                        NUMBER(10)
 GPS_Y_COORD                                        NUMBER(10)
 LOCATION                                           VARCHAR2(40)
 STATE                                              VARCHAR2(30)
 G3E_FNO                                            NUMBER(5)
 G3E_FID                                            NUMBER(10)SQL> select * from common_n;
select * from common_n
              *
ERROR at line 1:
ORA-00904: invalid column name