匯出db裡user的建立和授權的過程

kl911發表於2007-11-20

----建立user:

select 'create user ' || username || ' identified by values ''' || password
from dba_users;

----授權user:

select 'grant ' || granted_role || ' to ' || grantee || ';'
from DBA_ROLE_PRIVS;

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/661919/viewspace-983080/,如需轉載,請註明出處,否則將追究法律責任。

相關文章