首页 > 应用开发 > IT综合 > 导出db里user的创建和授权的过程
----创建user:
select 'create user ' || username || ' identified by values ''' || password
from dba_users;
----授权user:
select 'grant ' || granted_role || ' to ' || grantee || ';'
from DBA_ROLE_PRIVS;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/661919/viewspace-983080/ ,如需转载,请注明出处,否则将追究法律责任。