| Subject | Re: [firebird-support] sysdba versus other user |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-05-01T11:04:53Z |
At 06:18 PM 1/05/2005 +1000, you wrote:
destructive rights over all databases, whether it owns them or not.
environment variables that you can set (with caution!!) to the username and
password respectively that you want to use at the command line. Usually,
you set them temporarily in your private environment as the SYSDBA and its
password, in order to do administrative command-line tasks without needing
to enter them as command-line switches.
./heLen
>I have found that I can create a database by offering ISC_USER = [owner]SYSDBA is a real user (the server's superuser). It has complete
>rather than SYSDBA.
>
>Is there anything special about SYSDBA?
>
>Is SYSDBA just a convention
destructive rights over all databases, whether it owns them or not.
>or is the ISC_USER at database creationI don't really understand the question. ISC_USER and ISC_PASSWORD are
>time the real dba?
environment variables that you can set (with caution!!) to the username and
password respectively that you want to use at the command line. Usually,
you set them temporarily in your private environment as the SYSDBA and its
password, in order to do administrative command-line tasks without needing
to enter them as command-line switches.
./heLen