Little Star Blog

路在脚下,心向远方

Oracle Database 用户相关

使用sysdba登陆 sqlplus sys/oracle as sysdba 查询DBA权限用户 select GRANTEE as username,admin_option from dba_role_privs where GRANTED_ROLE='DBA' 使用账号密码登录 sqlplus username/password 如:普通用户登录 sqlplus scott/tiger sqlplus username/password as sysdba 如:sqlplus sys/admin as sysdba sqlplus username/password@net_service_name 如