Database Security Products (MOSC)

MOSC Banner

Restricted Access to other schemas

edited Jun 26, 2010 3:01AM in Database Security Products (MOSC) 11 commentsAnswered
Hi,
i have added a new Schema in our Oracle 10.2.0.4 Database:

Create Tablespace $TSNAME$ Datafile '$DBPATH$\$TSNAME$.dbf' Size 1000M autoextend on next
200M;

create user $DBUSER$ identified by $PASSWD$;
alter user $DBUSER$ default tablespace $TSNAME$;

grant create view to $DBUSER$;
grant connect to $DBUSER$;
grant resource to $DBUSER$;

grant select any table to $DBUSER$;
grant insert any table to $DBUSER$;
grant delete any table to $DBUSER$;



So everything works fine so far. But I can access other schemas too. That should not be.

Found something but this doesn´t work:

Begin
  For i in (select owner, table_name from dba_tables where owner not like '%SYS%')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center