Granting RESOURCE automagically grants UNLIMITED TABLESPACE... if that's
what you want... create object anywhere.
I start with a new role combining the old CONNECT and RESOURCE roles.
I believe they both someday will be deprecated, but not sure anymore
since it takes so long. I handle quotas separately and don't believe
in unlimited tablespace.
You may have noticed that the catch all used by third parties in your
database is: CONNECT, RESOURCE, and DBA. At this point their app will
last until your out of disk space. But if use DBA's wanted the app to
be a DBA with unlimited tablespace, we would make it one ourselves.
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: Stephen Tent
[mailto:oracledba-ezmlmshield-x66303168.[Email address protected]
Sent: Tuesday, October 30, 2007 2:10 PM
To: LazyDBA Discussion
Subject: RE: please answer the following question?( Oracle 9i)
In Oracle 9i you should NOT grant CONNECT if you only want the user to
be able to connect to the database; you should "grant create session to
username".
In Oracle 10g the CONNECT role has been stripped down to include only
the CREATE SESSION privilege.
Stephen Tent | Oracle DBA | City of Toronto | phone 416-392-4802
>>> "Ankur_Kashyap "
<oracledba-ezmlmshield-x55261275.[Email address protected] Oct 30,
2007 08:41 AM >>>
Hi,
For just connecting, GRANT CONNECT, and for letting a user work
;-). GRANT RESOURCE.
Regards
Ankur Kashyap
-----Original Message-----
From: Ravi Kumar
[mailto:oracledba-ezmlmshield-x54081675.[Email address protected]
Sent: Tuesday, October 30, 2007 6:08 PM
To: LazyDBA Discussion
Subject: please answer the following question?( Oracle 9i)
Hi Experts
Could you please answer the following question?( Oracle 9i)
When creating a user, what permissions must you grant to allow them to
connect to the database?
Thanks
Ravi
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page