restricting a user to access his own tables

[nunnasujatha]

Hi all,

as a super user i want to restrict a user created by me to access only the tables created by him/her.

i.e he only can access or change the data in the tables created by him.and can not do anything on other's tables.

is there any grant command to do this. or is this the case by default.

pls help me out.

thanks in advance.

[rectoverso]

Hi all,

as a super user i want to restrict a user created by me to access only the tables created by him/her.

i.e he only can access or change the data in the tables created by him.and can not do anything on other's tables.

is there any grant command to do this. or is this the case by default.

pls help me out.

thanks in advance.

if the tables are'nt in this user schema you can revoke the updates privileges to to user from this tables (a user must have a privilege to do an operation in another schema tables)

if the tables are in the user schema so you can write a system trigger that fires updates on tables and thereso block the updates for this user



you can write a system trigger that fires updates in the tables and ver

[Dave44]

Hi all,

as a super user i want to restrict a user created by me to access only the tables created by him/her.

i.e he only can access or change the data in the tables created by him.and can not do anything on other's tables.

is there any grant command to do this. or is this the case by default.

pls help me out.

thanks in advance.

Yes, by default a user can only see/modify his/her own objects and must be granted privileges to even view data from another schema (user).

Of course there are some dictionary tables and views that the user can select from, but they cannot alter the dictionary tables by default.

[rectoverso]

Yes, by default a user can only see/modify his/her own objects and must be granted privileges to even view data from another schema (user).

Of course there are some dictionary tables and views that the user can select from, but they cannot alter the dictionary tables by default.

another way is the policy

you can do a policy that restrict the access for a user