Subject Re: Confussion over passwords: Tells me my user name and password are not define
Author blizzardb2001
In our scenario, we want to restrict access to the database using a password on the SYSDBA user.
But in deployment, how is this possible? As I understand it, every time I copy the database file to a new computer, it will not remember the password.
Can you give please me some advice?
--- In, Dimitry Sibiryakov <sd@...> wrote:
> > What gives?
> Users (with passwords) belong to server, not database.
> > How am I supposed to deploy a database file if it's going to keep giving me this message.
> If you deploy empty database - ask user name which will be used as a
> database owner before it's creation at customer's site.
> If you deploy database, full of data - don't care about user name,
> grant SELECT to PUBLIC.
> SY, SD.