Re: Create User

On 18 Jun 2002 07:41:40 -0700, Charlie3101_at_hotmail.com (Charlie Edwards) wrote:

>tswier_at_yahoo.com (Tom Swier) wrote in message news:<8098db11.0206180257.56a109bb_at_posting.google.com>...
>> Before you do anything, read the Oracle documentation and set up your
>> own roles. It will give you the reasoning behind setting up roles, how
>> to do it and what privileges to assign to the roles. Using roles is
>> the only way to go if you have more than just a few users. I also
>> agree with Mr. Rogers about the use of the CONNECT role for 2 reasons:
>>
>> 1. It is a potential security breach because of some of the privileges
>> it grants.
>>
>> 2. In Oracle's own words "...roles are provided to maintain
>> compatibility with previous versions of Oracle and may not be created
>> automatically in future versions of Oracle. Oracle Corporation
>> recommends that you design your own roles for database security,
>> rather than relying on these roles."
>>
>> I have no problem with the posters here giving you the syntax for
>> creating users since that was your request, but 30 minutes spent
>> reading the documentation will make you feel a lot more comfortable
>> about what you are doing.
>>
>> Tom Swier
>
>Just out of curiosity, what privileges does connect (and resource for
>that matter) grant?
>
>I haven't been a DBA in anger since V5 (i.e. before roles) when you
>needed connect to get onto the database, resource to create objects
>etc.
>
>CE

select * from dba_sys_privs where grantee in ('CONNECT','RESOURCE') will answer your question

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jun 18 2002 - 12:43:30 CDT