在sql plus中只知sys用户密码情况下如何切换到任意用户。
今天是2013-12-15,之前遇到这么一个问题,最为数据库管理员,只有sys用户密码,不知道应用账户 密码,那么在使用sqlplus的时候如何切换到任意用户呢?且在切换中不会对用户访问产生影响?
答案是设置proxy用户:
eg:
SQL> create user sudo identified by proxy;
User created.
SQL> grant connect to sudo;
Grant succeeded.
SQL> alter user AMY grant connect through sudo;
User altered.
SQL> show user
USER is "SYS"
SQL> conn sudo[amy]/proxy;
Connected.
SQL> show user
USER is "AMY"
SQL>