OraFAQ Forum: Security » user creation

Home » RDBMS Server » Security » user creation (oracle 11g, windows 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user creation [message #519416]

Fri, 12 August 2011 00:26

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

Littlefoot
Messages: 21823
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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Littlefoot
Messages: 21823
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

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

cookiemonster
Messages: 13966
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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 23:23:43 CDT 2025