so_damn_insane ([info]so_damn_insane) rakstīja,
@ 2005-11-10 11:47:00

Previous Entry  Add to memories!  Tell a Friend!  Next Entry
alter session
login schema1/schema1 @ db

> create table schema1.test_table (id number(1));

Table created.

> insert into shchema1.test_table values(1);

1 row created;

> commit;

Commit complete;

> grant select on test_table to schema2;

Grant succeeded.

> commit;

Commit complete;


login schema2/schema2 @ db

> select * from schema1.test_table;

ID
---------
1

> select * from test_table;

ERROR at line 1:
ORA-00942: table or view does not exist

> alter session set current_schema = schema1;

Session altered

> select * from test_table;

ID
---------
1


(Lasīt komentārus)

Nopūsties:

No:
Lietotājvārds:
Parole:
Ievadi te 'qws' (liidzeklis pret spambotiem):
Temats:
Tematā HTML ir aizliegts
  
Ziņa:
Neesi iežurnalējies. Iežurnalēties?