| Subject | Re: [firebird-support] Permissions to delete users. |
|---|---|
| Author | Helen Borrie |
| Post date | 2007-01-22T22:59:33Z |
At 09:11 AM 23/01/2007, you wrote:
except through an updatable view that allows them to modify their own
account. Delete privs and write privs on other users' accounts are
not available to the view.
the -database switch and a full path to the security database.
./heLen
>I'm using the services API to manage accounts for the application'sIn Fb2 ordinary users don't get access to the security database
>database. The program it's able to create and update the accounts but
>any time I try to delete them I get the error "no permission for
>delete/write access to TABLE USERS" which suggest that the user
>doesn't have enough privileges on the security2.fdb database.
except through an updatable view that allows them to modify their own
account. Delete privs and write privs on other users' accounts are
not available to the view.
>Is there any way to give the user DELETE privileges on security2.fdb?No. Only the SYSDBA user can delete accounts, using GSEC with
the -database switch and a full path to the security database.
./heLen