[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Allow user to fully access a tablespace!!  HELP!!!

Posted on 2004-10-20
7
Medium Priority
?
338 Views
Last Modified: 2010-08-05
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.
0
Comment
Question by:Intern
  • 3
  • 2
  • 2
7 Comments
 
LVL 40

Expert Comment

by:jlevie
ID: 12364277
What database?
0
 
LVL 1

Author Comment

by:Intern
ID: 12364292
Sorry - I am running the entire 10g suite, so the database is 10.0.2.3 (I think)
0
 
LVL 40

Assisted Solution

by:jlevie
jlevie earned 400 total points
ID: 12364541
Okay so it is Oracle. How are the users accessing the database? If they are using the command line tool and they specify DEV as tablespace to open they should be able to use the simple form of the query.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 1

Accepted Solution

by:
pfinch earned 1600 total points
ID: 12367728
Hey,

I assume you have created a user and schema for "dev".

If you create the users that want to use dev as proxy users this should allow the users to access tables with out the "dev." prefix.

Regards,
Peter
0
 
LVL 1

Author Comment

by:Intern
ID: 12370168
Alright let me explain the main problem.  I am developing an app in Forms, and I do not want to fully qualify the name of each table.  The users will open the form from portal via single sign-on.  Then the form fails because all the tables are not fully qualified.

Peter:
What do you mean by having the users use dev as a proxy user?
0
 
LVL 1

Expert Comment

by:pfinch
ID: 12370505
A proxy user is a user without a schema.

So you can point the proxy user to the dev schema, and they should not need to use fully qualified names.

Load up oracle enterprise manager and you will see how to add proxy users.

Regards,
Peter
0
 
LVL 1

Author Comment

by:Intern
ID: 12370716
Thank you so much for the advice...  It will help me alot.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
I have written articles previously comparing SARDU and YUMI.  I also included a couple of lines about Easy2boot (easy2boot.com).  I have now been using, and enjoying easy2boot as my sole multiboot utility for some years and realize that it deserves …
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Suggested Courses
Course of the Month18 days, 15 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question