Home » RDBMS Server » Security » user creation (oracle 11g, windows 2008)
user creation [message #519416] Fri, 12 August 2011 00:26 Go to next message
vasee
Messages: 3
Registered: July 2011
Junior Member
i have been trying to create a user with full access on default Tablespace so that i can access all the objects without any restrictions for the new user. Any suggestions will help a lot.

thank you
Re: user creation [message #519420 is a reply to message #519416] Fri, 12 August 2011 01:08 Go to previous messageGo to next message
Littlefoot
Messages: 21481
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What objects do you call "all objects"? Who do they belong to?
Re: user creation [message #519424 is a reply to message #519416] Fri, 12 August 2011 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 66438
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either you mean its own objects then just give quota on this tablespace.
Either you mean all objects of any accounts in this tablespace and this one only then you cannot restrict privileges to a specific tablespace. Either the account has privileges on all schemas either it has only on its own.

Regards
Michel
Re: user creation [message #519436 is a reply to message #519424] Fri, 12 August 2011 02:40 Go to previous messageGo to next message
vasee
Messages: 3
Registered: July 2011
Junior Member
Thanks for quick response.

Actually my requirement is i have schema x with user x and default tablespace y. now i have created a user z with default tablespace y who has to share schema x with already existing user x that's what i mean "all objects".

Re: user creation [message #519437 is a reply to message #519436] Fri, 12 August 2011 02:44 Go to previous messageGo to next message
Littlefoot
Messages: 21481
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
User X owns his objects (located in his own schema). A new user (Z) can share X's objects only if X grants him privileges.
Re: user creation [message #519452 is a reply to message #519437] Fri, 12 August 2011 04:35 Go to previous messageGo to next message
vasee
Messages: 3
Registered: July 2011
Junior Member
yes now i can access the schema x as a user z from the sqlplus, but not able to access schema x from the third party tools like navicat with user z.
Re: user creation [message #519453 is a reply to message #519452] Fri, 12 August 2011 04:53 Go to previous messageGo to next message
cookiemonster
Messages: 13630
Registered: September 2008
Location: Rainy Manchester
Senior Member
That would be a question for the makers of navicat
Re: user creation [message #519454 is a reply to message #519452] Fri, 12 August 2011 04:53 Go to previous message
Michel Cadot
Messages: 66438
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then you don't connect as user z and you don't connect to the same database.
For Oracle there is NO difference you connect from any client tool.

Regards
Michel
Previous Topic: Schema consolidation and user schema mapping based on service?
Next Topic: Limit access to user
Goto Forum:
  


Current Time: Thu Jun 20 12:20:46 CDT 2019