这里的需求是要给LYPROG用户赋予同义词权限,并把'GRIDPROG','SJ_PROG'两个用户的对象都赋权给输入的用户名下
oracle@grid-oracle-01:/home/oracle$ ss
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 24 16:14:09 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select distinct user from dba_users;
USER
------------------------------
SYS
SQL> select username from dba_users;
USERNAME
------------------------------
LYPROG
JKPROG
OOZIE
OOZIEADMIN
HIVE
HIVEADMIN
SJ_PROG
SDE
GRIDPROG
GRIDADMIN
GRIDKEEPER
USERNAME
------------------------------