Home » RDBMS Server » Security » oracle security settings and acess limits.
oracle security settings and acess limits. [message #168234] Wed, 19 April 2006 06:49 Go to next message
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 ?
Re: oracle security settings and acess limits. [message #168237 is a reply to message #168234] Wed, 19 April 2006 07:08 Go to previous messageGo to next message
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.
Re: oracle security settings and acess limits. [message #168239 is a reply to message #168237] Wed, 19 April 2006 07:18 Go to previous message
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
Previous Topic: Creating Before On logon Trigger in Oracle
Next Topic: Duplicate users to another machine
Goto Forum:
  


Current Time: Thu Mar 28 06:49:13 CDT 2024