Allow user to fully access a tablespace!! HELP!!!
Posted on 2004-10-20
I want to create all of our database users for the company, and allow them to have full privilages on a certain tablespace "DEV".
How can I create users and have the user function just like the owner of that tablespace?
i.e. select * from inv_detail;
instead of having them do
select * from dev.inv_detail;
Can anyone help me out, does this require me to make public synonyms for everything in the database or can I do it a different way? I have already created a role granting them access to the tables in DEV, but they would still have to fully qualify the tablename.