When implementing the create user (user name) identified by (password);
Conn user name as sysdba
Grant create any table to user name;
Grant, unlimited in tablespace to username;
And so on authorized operation
Only to authorized users, users are sys, at this time when you realize the conn username/password
Can't operate grant create any index to username; Of the operation, when the user has only just grant rights
,
I compare food, took a long time to sort out

CodePudding user response:

This is used to write up sqlplus,
In SQL developer to write, in the initial interface is created, you need to create a just set up the user and password to log in