lab1

SQL> CREATE USER kostya identified BY kostya
  2  DEFAULT tablespase users
  3  temporary tablespace temp
  4  quota 1M ON users;
DEFAULT tablespase users
        *
ERROR AT line 2:
ORA-00921: unexpected END OF SQL command


SQL> CREATE USER kostya identified BY kostya
  2  DEFAULT tablespace users
  3  temporary tablespace temp
  4  quota 1M ON users;

USER created.

SQL> GRANT CONNECT, RESOURCE, CREATE VIEW TO demo
  2  ;

Grant succeeded.

SQL> CONNECT kostya/kostya
ERROR:
ORA-01045: USER KOSTYA lacks CREATE SESSION privilege; logon denied


Warning: You are no longer connected TO ORACLE.
SQL> CREATE TABLE human(
  2  human_id NUMBER(3,0) NOT NULL,
  3  first_name VARCHAR(40) NOT NULL,
  4  last_name VARCHAR(40) NOT NULL,
  5  age NUMBER(3,0) NOT NULL,
  6  primary key(human_id));
SP2-0640: NOT connected
SQL> GRANT CONNECT, RESOURCE, CREATE VIEW TO demo
  2
SQL>
SQL> GRANT CONNECT, RESOURCE, CREATE VIEW TO kostya;
SP2-0640: NOT connected
SQL> CONNECT system/oracle
Connected.
SQL> GRANT CONNECT, RESOURCE, CREATE VIEW TO kostya
  2  ;

Grant succeeded.

SQL> CONNECT kostya/kostya
Connected.
SQL> CREATE TABLE human(
  2  human_id NUMBER(3,0) NOT NULL,
  3  first_name VARCHAR(40) NOT NULL,
  4  last_name VARCHAR(40) NOT NULL,
  5  age NUMBER(3,0) NOT NULL,
  6  primary key(human_id));

TABLE created.

SQL> INSERT INTO human(1, 'kostya', 'nekostya', 20)
  2  ;
INSERT INTO human(1, 'kostya', 'nekostya', 20)
                  *
ERROR AT line 1:
ORA-00928: missing SELECT keyword


SQL> INSERT INTO human VALUES (1, 'kostya', 'nekostya', 20);

1 ROW created.

SQL> COMMIT
  2  ;

COMMIT complete.