Re: How to export user with USERID without password

"Epicentre Team A ANNECY" <djeanneret_at_epicentre.fr> wrote in message news:<a7c94v$mg8$1_at_wanadoo.fr>...
> Hello
>
> Is possible to export User with USERID but without PASSWORD ?

Do you mean is it possible to export a user without knowing the user's password (1) or for the export to not contain the 'hashed' password (2), or are you asking about in the UNIX environment (3)?

1 - The DBA can perform an export of a user's object without knowing the user password

2 - On a user export the create user statement is not written to the export. On a full export the create user statements are written and the 'hashed' password will be present. But you can easily generate the create user DDL from the dba_users table.

3 - In the unix environment you can [korn shell] export USER=testid and then issue sqlplus $USER and sqlplus will prompt for the password, but this would not work from Pro*c. This will also work with exp and imp.

HTH, but your question was not clear to me. Perhaps someone else will recognize what you are asking. -- Mark D Powell -- Received on Thu Mar 21 2002 - 08:17:02 CST