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

Report message to a moderator

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: 21648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What objects do you call "all objects"? Who do they belong to?

Report message to a moderator

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: 67667
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

Report message to a moderator

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".

Report message to a moderator

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: 21648
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.

Report message to a moderator

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.

Report message to a moderator

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: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
That would be a question for the makers of navicat

Report message to a moderator

Re: user creation [message #519454 is a reply to message #519452] Fri, 12 August 2011 04:53 Go to previous message
Michel Cadot
Messages: 67667
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 27 21:27:23 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.