Install oracle 11 g without some password management, how to set up and modify,

Want to use the EMP table but under the Scott user, how to do

Solution to solve

CodePudding user response:

With permission of the user login, usually sys, execution:
The alter user XXX identified by yyy account unlock;
Set the password and unlock, identified by yyy is behind you want to set password

Other users to use the table:
1, want to have access to the other user table;
2, refer to the table when combined with the user name, such as: Scott. The emp

CodePudding user response:

In front of the table name and use it every time it is ok to add the user name
SELECT * FROM scottt. Emp