Operations for Oracle users __oracle

1. Create user

Sql> Create user Jack identified by Jack;

2. Change Password

Sql> alter user Jack identified by Rose;

3. Authorized users

Sql> Grant Dba,resource,connect to Jack;

4. Permission to receive

Sql> revoke DBA from Jack;

5. Lock users

sql> ALTER user Jack account lock;

sql> alter user Jack account unlock (unlock)

6. Permission transfer (this user has create DBA authority)

Sql> Grant DBA to jack with admin option;

7. Specify the table space and available size to the user
sql> ALTER user Jack default tablespace testspace quota 3m on Testspace;

8. View Current User
Sql> Select User from dual; or show user;