| Tablespace query [message #64600] |
Sat, 12 February 2005 01:06  |
amarjeetkaur
Messages: 1
Registered: February 2005
|
Junior Member |
|
|
Oracle version :- 8.1.6
operating System :- Linux
I have created user scott, default tablespace of this user is first and quota 1m on second.
create user scott
identified by scott
default tablespace first
temporary tablespace temp
quota 1m on first
quota 2m on second;
Now scott has created segments in first as well as second , now i wanted to remove quota from second
alter user scott
quota 0 on second
But i don't want that this user can select any segment from second, i can't use select on object privlege coz 2 many tables are there in second.
So how can i revoke select from tablespace second from user scott.
|
|
|
|
|
|
|
|
| Re: Tablespace query [message #109743 is a reply to message #64600] |
Mon, 28 February 2005 08:57  |
dbalaji_oracle
Messages: 4
Registered: February 2005
|
Junior Member |
|
|
i think u are very much confused on the requirement.
the tables are created by scott himself then how can u restrict his access from tablespace 2.
the best way is to move theose tables intablespace2 the tablespace1 or just move these tables to another user schema and restrict the access.
hope this works.
DBAlaji
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
