SQL> show user;
USER is "SCOTT"
SQL> connect system/narsan as dba;
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SQL> connect system/narsan as sysdba;
Connected.
SQL> show user;
USER is "SYS"
SQL> grant create any to scott;
grant create any to scott
*
ERROR at line 1:
ORA-00990: missing or invalid privilege
SQL> grant create any view to scott;
Grant succeeded.
SQL> connect
scott/tiger;