Subject | Re: [firebird-support] Define users |
---|---|
Author | Ivan Prenosil |
Post date | 2004-06-28T22:02:33Z |
From: "Paul Vinkenoog"
- Create the database and specify the owner among other parameters
Only SYSDBA and database owner have rights to
-backup database
-shutdown database
-drop database
-set some parameters, like sweep interval, etc.
Ivan
> > * I design a database and grant access to a user other than SYSDBAIn fact it is just one-step process, you do not make any "dummy" connection:
> > e.g. MASTERUSER
>
> If you want MASTERUSER to be the owner of the new database, you:
>
> - Connect to the Firebird server as MASTERUSER.
> - Create the database.
- Create the database and specify the owner among other parameters
>But ownership of database can't be granted.
> If you create the db as SYSDBA, you can grant any rights you want to
> MASTERUSER but that's more work.
Only SYSDBA and database owner have rights to
-backup database
-shutdown database
-drop database
-set some parameters, like sweep interval, etc.
Ivan