Permission management
1. The default three users
2. Create a user
3. Grant and revoke permissions.
4. System and object permissions
5. Role
6. manage permissions through roles
7. What should I do if the administrator password is lost during permission transfer?
Three default users
Username and password
Sys change_on_install
System manager
Scott tiger
Cmd
Go to the command line
Sqlplus/as sysdba;
Or
Sqlplus sys/change_on_install as sysdba;
Log On As the network database administrator sys
To connect to the database, you must start the oracle instance and the listening service;
Start listening: lsnrctl start;
Start the instance: oradim-starup-sid orcl;
Show user;
Show current Login User
Create user lisi identified by lisi;
Create a new user lisi;
Sqlplus lisi/lisi;
Use the newly created user lisi to log on
Administrator user authorization for new user
Log on as an administrator
Grant create session to lisi;
Grant the session permission to connect to the database;
Grant create table to lisi;
Grant table creation permission
Grant unlimited tablespace to lisi;
Grant unlimited tablespace Permissions
A table can be created only after permissions are granted.
Log On As A lisi user
Create table mytable (id int );
Create a table
Insert into mytable values (1 );
Insert record
Select * from mytable;
Query records
Revoke permissions
Revoke create table from lisi;
View User Permissions
Select * from user_sys_privs;
Change User Password
Alter user username identified by password;
Not complete...
