Rights Management
1, default of three users
2, create user
3, Authorization, REVOKE permissions
4, System permissions and object permissions
5, role
6, Manage permissions by role
7. How to pass the permission, lose the administrator password
3 Default Users
User name password
SYS Change_on_install
System Manager
Scott Tiger
Cmd
Go to command line
Sqlplus/as Sysdba;
Or
Sqlplus Sys/change_on_install as SYSDBA;
Log in as Network Database administrator Sys
The Oracle instance and listener service must be started to connect to the database;
Start monitoring: Lsnrctl start;
Launch instance: Oradim-starup-sid ORCL;
Show user;
Show currently logged on user
Create user Lisi identified by Lisi;
Create a new user Lisi;
Sqlplus Lisi/lisi;
Log in with the newly created user Lisi
Administrator user Authorization for newly created user
Log in with an administrator
Grant create session to Lisi;
Grant session permissions, with this permission to connect to the database;
Grant CREATE table to Lisi;
Grant permissions to create a table
Grant unlimited tablespace to Lisi;
Granting Unrestricted Table space permissions
Permissions are granted before tables can be created
Log in as Lisi user
CREATE TABLE mytable (id int);
Create a table
INSERT INTO mytable values (1);
Inserting records
SELECT * FROM MyTable;
Query records
Revoke permissions
Revoke CREATE table from Lisi;
To view the permissions that a user has
SELECT * from User_sys_privs;
Modify User Password
Alter user username identified by password;
Not to be continued ...
