If you really want to grant all objects to another user, you can get out of the 'grant' ,you can use database link.
The following example grants all objects belong to scott privileges to eagle
SQL> create user eagle identified by eagle;
User created.
SQL> grant create session to eagle;
Grant succeeded.
SQL> grant create database link to eagle;
Grant succeeded.
SQL> grant select any table to eagle;
Grant succeeded.
SQL> connect eagle/eagle@test
Connected.
SQL> create database link scott_test connect to scott identified by tiger using
'test';
Database link created.
SQL> select * from emp@scott_test;
SAL MGR EMPNO
---------- ---------- ----------
10 1342 1000
10 1342 2000
50 1342 2000
60 1342 2000
SQL>
发表评论
-
dblink 阀值
2013-09-06 04:53 480调整方法: alter system set open_l ... -
查看 运行中的存储过程
2013-08-29 23:45 7761、查看ORACLE中正在运 ... -
oracle seconds to hh:mm:ss format
2013-03-13 02:26 959SELECT TO_CHAR(TRUNC(x/36 ... -
listener.ora、sqlnet.ora、tnsnames.ora
2013-03-06 04:57 736oracle网络配置 三个配置文件 listener.or ... -
oracle ratio_to_report
2013-02-20 03:20 901Ratio_to_report函数 Syntax ... -
Oracle 获取本周、本月、本季、本年的第一天和最后一天
2013-01-15 05:08 2673--取得当天0时0分0秒 select TRUNC ... -
package UTL_MAIL - 04042
2012-12-14 03:53 586Connect as SYS as sysdba: ... -
oracle常用的时间函数
2012-12-14 03:09 834SELECT SYSDATE FROM DUAL 取当前系 ... -
oracle ash awr addm 三把利剑 ---转贴
2012-10-19 04:53 782原文出处:http://space.itp ... -
expdp/impdp 进行数据库迁移例子
2012-09-21 01:59 842把一个数据库上的一个用户schema迁移到另外一个数据库上 ... -
数据库缓冲区命中率
2012-09-19 21:55 712数据库缓冲区命中率 select name,value ... -
oracle真实案例之oem大量占用cpu与内存问题的解决方法
2012-09-14 23:13 8723一、介绍 由于dba离职,所以公司所有的or ... -
oracle 权限管理
2012-09-07 04:41 6021.查看所有用户: select * from db ... -
impdp 在同一个数据库中把一个schema中所有的对象复制到另一个schema中
2012-09-07 02:03 1171在同一个数据库中把一个schema中所有的对象复制到另一个sc ... -
11g MEMORY_TARGET 参数对SGA 和PGA的影响
2012-09-06 04:32 83111g 中新增 MEMORY_MAX_TARGET 参数 ... -
每小时生成csv文件,并ftp到远端服务器
2012-08-17 03:31 2416CREATE OR REPLACE procedu ... -
全面学习DBMS包之DBMS_SQL (转贴)
2012-08-16 22:32 682在PL/SQL编程当中,经常 ... -
Oracle – Select sysdate +/- time from dual
2012-08-15 22:39 892如果想+,-系统时间: Sysdate: S ... -
ZT 查看Oracle数据库表空间大小(空闲、已使用),是否要增加表空间的数据文件
2012-08-08 23:15 850--1查看表空间已经使用的百分比 ... -
Oracle使用虚拟表dual一次插入多条记录
2013-03-13 02:29 1040BEGIN generate_tmpsh ...
相关推荐
mysql 赋给用户权限 grant all privileges on.docx
in the event You determine that any particular Registered End User will no longer be permitted to use the Registered Software, You may register a different individual by sending email requesting a ...
grant select on testdb.* to common_user@'%' grant insert on testdb.* to common_user@'%' grant update on testdb.* to common_user@'%' grant delete on testdb.* to common_user@'%' 或者,用一条 MySQL 命令...
GRANT SELECT ON "SYS"."ALL_TABLES" TO "MAPGISDBA" WITH GRANT OPTION; GRANT SELECT ON "SYS"."V_$SESSION" TO "MAPGISDBA" WITH GRANT OPTION; GRANT SELECT ON "SYS"."DBA_USERS" TO "MAPGISDBA" WITH ...
代码如下:grant select on testdb.* to common_user@’%’grant insert on testdb.* to common_user@’%’grant update on testdb.* to common_user@’%’grant delete on testdb.* to common_user@’%’ ...
CMD Script to grant Everyone acces to a folder or more.
MySQL的Grant命令详解
UPDATE user SET Password=PASSWORD('newpassword') WHERE user='root'; mysql>; FLUSH PRIVILEGES; 允许远程登录 mysql -u root -p Enter Password: <your new password> mysql>GRANT ALL PRIVILEGES ON *.*...
grant select on testdb.* to common_user@'%' grant insert on testdb.* to common_user@'%' grant update on testdb.* to common_user@'%' grant delete on testdb.* to common_user@'%' 或者,用一条
grant connect,resource to tcy; --把connect(这种是临时用户),resource(这种是可以创建视图存储过程...)权限给tcy用户 revoke resource from tcy;--撤消对tcy用户的resource权限 crant select on vote_user to ...
grant all on test.* to root@'%' identified by '123321'; grant all on test.* to root@localhost identified by '123321'; grant all on 数据库名.* to 数据库用户名@'%' identified by '访问密码'; grant all ...
cmd输入 sqlplus; 回车,然后输入 system as sysdba; 登录依次执行 创建表空间 ... 创建用户执行: ... 为用户赋权限执行: ... GRANT CONNECT TO 用户名; GRANT RESOURCE TO 用户名; GRANT DBA TO 用户名;
It can request all your declared permissions in a single method and give you a callback when they have been granted. It can perform a task at some point in the future that requires a specific ...
GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION; user:myuser pwd:mypassword 从192.168.1.3连接到mysql服务器 GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’...
grant all privileges on *.* to ‘jirauser’@'%’ identified by ‘jira’ with grant option; grant all privileges on *.* to ‘jirauser’@'localhost’ identified by ‘jira’with grant option; flush ...
-- Grant/Revoke system privileges grant unlimited tablespace to BOS; Spring 环境搭建 IOC 导入 context 依赖 beans、core、expression AOP 导入 测试集成 Web 集成 配置监听器 整合持久层框架 ...
有两个不同的方法增加用户:通过使用GRANT语句或通过直接操作MySQL授权表。比较好的方法是使用GRANT语句,因为他们是更简明并且好像错误少些。本文将为大家介绍MySQL数据库中如何用GRANT语句增添新用户。
ocp 题库 1Z0-047题库.pdf,想考过ocp的同志们,参考一下