OraFAQ Forum: Security » oracle security settings and acess limits.

Home » RDBMS Server » Security » oracle security settings and acess limits.

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

oracle security settings and acess limits. [message #168234]

Wed, 19 April 2006 06:49

varsham
Messages: 3
Registered: April 2006

Junior Member

How do i create a user with sysdba privilege ?
where can I find orapwd utility in Oracle 10. Am new in using Oracle and I have to verify some oracle security settings and acess limits.
Please help me

init.ora file in the path /u01/app/oracle/product/10.2.0/db_1/dbs has to
log_archive_start = true but this is commented out in My case.
Can I uncomment it ? Does it affect any thing else ?

Report message to a moderator

Re: oracle security settings and acess limits. [message #168237 is a reply to message #168234]

Wed, 19 April 2006 07:08

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

To be very honest you want to learn a lot on a fly and it's really not a good way.

--> How do i create a user with sysdba privilege ?

Read the documentation related to user creation.

Little briefing -- http://www.orafaq.com/faq/how_does_one_create_manage_and_drop_database_users

--> where can I find orapwd utility in Oracle 10 .

All the executables are stored at $ORACLE_HOME/bin location

-->log_archive_start = true but this is commented out in My case.
Can I uncomment it ? Does it affect any thing else ?

Depends on your requirement , read the docs related to Archive/No archive mode.

And just to add , try to read the manuals so that you can understand things completely.

Report message to a moderator

Re: oracle security settings and acess limits. [message #168239 is a reply to message #168237]

Wed, 19 April 2006 07:18

varsham
Messages: 3
Registered: April 2006

Junior Member

Thanks,
I tried logging in as sys and system user, but the only use given to me did not have any sysdba privileges.

Now logged in using /nolog option and then gave my user the sysdba permission.

I have another doubt, any article to read on this is also welcome Smile

when I logged in as / nolog , and did show user it gave me "" but then I could connect to sys as sysdba?

Is this the correct ? Can this logging as / nolog be removed ?

Thanks a lot

Varsha

Report message to a moderator

Previous Topic:	Creating Before On logon Trigger in Oracle
Next Topic:	Duplicate users to another machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 15:53:19 CST 2025