How passwords work

[simoesluciano]

Hello, I am a beginner in Oracle and I have some doubts about its operation. One is:

Users and passwords (sys, sysadmin, ...) are per installation environment or db? That is, if I restore a backup generated on an X machine on a Y machine, should I use which passwords (x and and have different passwords)?


Thanks.

[dr_gori]

It has an article in Márcio Portes blog about EXP with passwords. See this: http://mportes.blogspot.com/2006/09/exp ... enhas.html : -The

Sometimes we need to make an Export / Import and bring users and password (originals). For this, there is a small trick using the import file, see Example:

Select all

ops$marcio@YODA10G> !exp / file=users.dmp full=y 
 
Export: Release 10.2.0.2.0 - Production on Fri Aug 18 20:04:48 2006 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production 
With the Partitioning, OLAP and Data Mining options 
Export done in US7ASCII character set and AL16UTF16 NCHAR character set 
server uses WE8ISO8859P1 character set (possible charset conversion) 
 
About to export the entire database ... 
. exporting tablespace definitions 
. exporting profiles 
. exporting user definitions 
. exporting roles 
. exporting resource costs 
. exporting rollback segment definitions 
. exporting database links 
. exporting sequence numbers 
. exporting directory aliases 
. exporting context namespaces 
. exporting foreign function library names 
. exporting PUBLIC type synonyms           <<<<<-------- FIZ UM CTRL-c AQUI. 
EXP-00008: ORACLE error 1013 encountered ORA-01013: 
user requested cancel of current operation 
EXP-00000: Export terminated unsuccessfully  
 
ops$marcio@YODA10G> !strings users.dmp | grep -i ops$marcio 
CREATE USER "OPS$MARCIO" IDENTIFIED BY VALUES '780383AD56F94137' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" 
GRANT UNLIMITED TABLESPACE TO "OPS$MARCIO" 
GRANT "DBA" TO "OPS$MARCIO" 
ALTER USER "OPS$MARCIO" DEFAULT ROLE ALL

[ALAN WILSON RESENDE]

Hi!

SYS and System users passwords are defined by instance.

If you are importing the file for instance X.

Att.

Alan Resende
Oracle DBA.
Curitiba-PR.

[ALAN WILSON RESENDE]

Sorry.

I did not finish my sentence.

SYS and System users passwords are defined by instance.

If you are importing the file for X instance you must use the password of this instance.

Att.

[simoesluciano]

But this is too bad. If I have access to a backup file and restore on a local machine with a installation made by me I will have access to data without major difficulties.

or am I mistaken?