minimum roles to connect to an instance [message #50607] |
Mon, 25 March 2002 04:21 |
sai
Messages: 27 Registered: October 2001
|
Junior Member |
|
|
Hi all,
What are the minimum roles required for an user to connect to a database? Some users are able to connect
through SQlplus but not through DBA studio.
DBA studio says users doesnot have enough privileges
As always Thank you very much
Sai
|
|
|
|
Re: minimum roles to connect to an instance [message #50610 is a reply to message #50607] |
Mon, 25 March 2002 05:27 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
Roles 'connect' and 'resource' is fine, but I would think twice before granting 'dba' role to a user. It is a pretty powerful role.
Role 'connect' is the minimum required to be able to connect to the database and most users are OK with just this one. Role 'resource' is also fine but this also grants 'unlimited tablespace'. Most of my users have 'connect' and 'resource' granted, and then later on I take out the 'unlimited tablespace' piece.
|
|
|
|