全部博文
-
编辑 删除
【Oracle】将hr用户下所有对象导入到新建aa用户
起创始建aa用户： sys@ORCL>> create user aa identified by aa; User created. 用hr用户登录查看用户权限： sys@ORCL>> conn hr/hr Connected. hr@ORCL>> select * from session_privs; PRIVILEGE ---------------------------------------- CREATE SESSION ALTER SESSION UNLIMITED TABLESPACE CREATE TABLE CREATE CLUSTER CREATE SYNONYM CREATE VIEW CREATE SEQUENCE CREATE DATABASE LINK CREATE PROCEDURE CREATE TRIGGER CREATE TYPE CREATE OPERATOR CREATE INDEXTYPE 14 rows selected. hr@ORCL>>
