可以首先根据系统表查看并记录用户信息,在根据这些信息创建新用户。这样做一个存储过程就可以了。 下面提供一些创建用户的语法: 创建用户: CREATE USER username PROFILE DEFAULT IDENTIFIED BY password DEFAULT TABLESPACE UserTableSpaceName TEMPORARY TABLESPACE TempTableSpaceName ACCOUNT UNLOCK;删除用户: DROP USER username;增加权限: GRANT Connect TO username; GRANT Resource TO username; GRANT Unlimited Tablespace TO username;删除权限: REVOKE Unlimited Tablespace FROM username; REVOKE Connect FROM username; REVOKE Resource FROM username;修改表空间: ALTER USER username DEFAULT TABLESPACE OtherUserTableSpaceName; ALTER USER username TEMPORARY TABLESPACE OtherTempTableSpaceName;修改口令: ALTER USER username INDENTIFIED BY NewPassword;增加对象权限: GRANT INSERT/DELETE/UPDATE/SELECT/ALTER/INDEX/REFERENCES ON TableName TO username;删除对象权限: REVOKE INSERT/DELETE/UPDATE/SELECT/ALTER/INDEX/REFERENCES ON TableName FROM username;对象权限详细: TABLE :INSERT/DELETE/UPDATE/SELECT/ALTER/INDEX/REFERENCES VIEW :INSERT/DELETE/UPDATE/SELECT PACKAGES :EXECUTE SYNONYMS :INSERT/DELETE/UPDATE/SELECT/ALTER/INDEX/REFERENCES SEQUENCES :ALTER/SELECT TYPE :EXECUTE FUNCTION :EXECUTE PROCEDURES :EXECUTE QUEUES :ENQUEUE/DEQUEUE SNAPSHOTS :SELECT
1.建立用户
2.为用户授权
3.exp
4.imp fromuser= touser=
它可以实现你要实现的功能!!
下面提供一些创建用户的语法:
创建用户:
CREATE USER username
PROFILE DEFAULT
IDENTIFIED BY password
DEFAULT TABLESPACE UserTableSpaceName
TEMPORARY TABLESPACE TempTableSpaceName
ACCOUNT UNLOCK;删除用户:
DROP USER username;增加权限:
GRANT Connect TO username;
GRANT Resource TO username;
GRANT Unlimited Tablespace TO username;删除权限:
REVOKE Unlimited Tablespace FROM username;
REVOKE Connect FROM username;
REVOKE Resource FROM username;修改表空间:
ALTER USER username DEFAULT TABLESPACE OtherUserTableSpaceName;
ALTER USER username TEMPORARY TABLESPACE OtherTempTableSpaceName;修改口令:
ALTER USER username INDENTIFIED BY NewPassword;增加对象权限:
GRANT INSERT/DELETE/UPDATE/SELECT/ALTER/INDEX/REFERENCES
ON TableName TO username;删除对象权限:
REVOKE INSERT/DELETE/UPDATE/SELECT/ALTER/INDEX/REFERENCES
ON TableName FROM username;对象权限详细:
TABLE :INSERT/DELETE/UPDATE/SELECT/ALTER/INDEX/REFERENCES
VIEW :INSERT/DELETE/UPDATE/SELECT
PACKAGES :EXECUTE
SYNONYMS :INSERT/DELETE/UPDATE/SELECT/ALTER/INDEX/REFERENCES
SEQUENCES :ALTER/SELECT
TYPE :EXECUTE
FUNCTION :EXECUTE
PROCEDURES :EXECUTE
QUEUES :ENQUEUE/DEQUEUE
SNAPSHOTS :SELECT