Create a user with read only on ONE table
Hi!
How do I create a user which should have only READ (select) on one table in the database? Is it possible to create a user with NO password required for this?
CREATE USER test_user IDENTIFIED BY blabla
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
GRANT CONNECT, CREATE SESSION,
SELECT on testtable;
Testtable is owned by another user.
Regards
U
How do I create a user which should have only READ (select) on one table in the database? Is it possible to create a user with NO password required for this?
CREATE USER test_user IDENTIFIED BY blabla
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
GRANT CONNECT, CREATE SESSION,
SELECT on testtable;
Testtable is owned by another user.
Regards
U
0