Oracle user permission management

Three default users <br/> syschange_on_install [as sysdba] <br/> systemmanager <br/> scotttiger </P> <p> create user <br/> create user t0nsha identified by t0nsha; </P> <p> system permission <br/> grant create session to t0nsha; <br/> grant create table to t0nsha; <br/> grant unlimited tablespace to t0nsha; </P> <p> revoke create Session from t0nsha; <br/> revoke create table from t0nsha; <br/> revoke unlimited tablespace from t0nsha; </P> <p> Grant the session permission to all users <br/> grant create session to public; </P> <p> query the system permissions of the current user <br/> select * From user_sys_privs; </P> <p> transfer permissions <br/> assign alter any table to t0nsha, in addition, t0nsha can continue to grant alter any table to other users <br/> grant alter any table to t0nsha with admin option; </P> <p> Object permission <br/> grant select on mytab to t0nsha; </P> <p> grant all permissions of the mytab object to t0nsha <br/> grant all on mytab to t0nsha; </P> <p> revoke select on mytab from t0nsha; <B R/> revoke all on mytab from t0nsha; </P> <p> query the object permissions of the current user <br/> select * From user_tab_privs; </P> <p> object permissions are controlled to columns and only valid for insertion and update. query and deletion cannot be controlled to columns. <Br/> grant the update permission of column1 of mytab to t0nsha <br/> grant Update (column1) on mytab to t0nsha; <br/> grant insert (column2) on mytab to t0nsha; <br/> select * From user_col_privs; </P> <p> transfer permissions <br/> grant select on mytab to t0nsha, in addition, t0nsha can continue to grant select on mytab to other users <br/> grant select on mytab to t0nsha with grant option; </P> <p> role <br/> A role is a set of permissions and cannot be assigned to a role with unlimited tablespace. <br/> Create role myrole; <br/> grant creat E session to myrole; <br/> gratn create table to myrole; <br/> crant myrole to t0nsha; <br/> drop role myrole; </P> <p> Create Table: Create a table for yourself <br/> create any table: Create a table for another user </P> <p> alter user Scott identified by tiger; </P> <p> A table belongs to a user and its roles are shared by all users. </P> <p> adjust the width of the command line <br/> set linesize 400 </P> <p> data dictionary: view for saving system information </P> <p> display current user: Show user; </P> <p> three database verification mechanisms <br/> operating system verification (sysdba, sysoper) (ora_dba group, default) <br/> Password File verification (sysdba, sysoper) <br/> database verification (Scott) </P> <p> Oracle startup in Linux <br/> LSNRCTL start <br/> // earlier versions are not allowed: sqlplus sys/Oracle AS sysdba <br/> sqlplus/nolog <br/> conn sys/Oracle AS sysdba <br/> startup </P> <p> Windows Oracle startup process <br/> LSNRCTL start <br/> oradmi N-startup-Sid orcl </P> <p> Password File verification forgot password <br/> Delete the original password file <br/> Del E: /Oracle/product/10.2.0/db_1/database/pwdorcl. ora <br/> recreate the password file <br/> orapwd file = E:/Oracle/product/10.2.0/db_1/database/pwdorcl. ora Password = Oracle entries = 10 <br/> View the number of privileged users in the password file <br/> select * from V $ pwdfile_users; </P> <p> the Oracle database installed does not have the Oracle Enterprise Manager Console <br/> since 10 Gb, the OEM has changed from a previous software to an HTTP service on the server. You can choose this option when installing the server. On the client, if you need OEM tools, do not access them from HTTP. During installation, You need to select the client OEM tool of Java edition separately. By default, it is not checked. </P> <p> http://zhidao.baidu.com/question/149511191 </P> <p> ed