标红位置改为自己相应的,该例子为创建 READUSER只读USER的表
CREATE USER READUSER IDENTIFIED BY123;
GRANT CONNECT TO READUSER;
执行如下命令
select 'grant select on '||owner||'.'||object_name||' toUSER;'
from dba_objects
where owne
标红位置改为自己相应的,该例子为创建 READUSER只读USER的表
CREATE USER READUSER IDENTIFIED BY123;
GRANT CONNECT TO READUSER;
执行如下命令
select 'grant select on '||owner||'.'||object_name||' toUSER;'
from dba_objects
where owne