2014-07-09-first-terminal.txt

admin

[root@station90 ~]# su - oracle
[oracle@station90 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 9 19:27:07 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn sh/oracle_4U
Connected.
SQL> grant select on sales to hr with grant option;

Grant succeeded.

SQL> revoke select  on slaes from hr;
revoke select  on slaes from hr
                  *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> revoke select  on sales from hr;

Revoke succeeded.

SQL> grant  select  on sales to r1;

Grant succeeded.

SQL> grant r1 to hr with admin option;
grant r1 to hr with admin option
*
ERROR at line 1:
ORA-01919: role 'R1' does not exist


SQL> conn system/oracle_4U
ERROR:
ORA-28001: the password has expired


Changing password for system
New password:
Password unchanged
Warning: You are no longer connected to ORACLE.

SQL>
SQL>
SQL> conn system/oracle_4U
ERROR:
ORA-28001: the password has expired


Changing password for system
New password: *********
Retype new password: *********
Password changed
Connected.
SQL> show user
USER is "SYSTEM"
SQL> grant r1 to hr with admin option;

Grant succeeded.

SQL> revoke r1 from hr ;

Revoke succeeded.

SQL> revoke select  on sh.sales from r1 ;

Revoke succeeded.

SQL> grant select  on sh.customers to r1 ;

Grant succeeded.

SQL> revoke select  on sh.customers from r1 ;

Revoke succeeded.

SQL> revoke  r2  from r1 ;

Revoke succeeded.

SQL> revoke r1 from ops$oracle;

Revoke succeeded.

SQL> grant select_catalog_role to hr ;

Grant succeeded.

SQL> revoke  select_catalog_role  from hr;

Revoke succeeded.

SQL> grant select_catalog_role to hr ;

Grant succeeded.

SQL>