| Subject | Re: [firebird-support] Setting SQL privileges |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-11-25T06:51:50Z |
At 08:51 AM 25/11/2003 +0200, you wrote:
database are "opt-in" - every user except sysdba and Owner must be granted
privs to get any access. You can't prevent sysdba access anywhere, so if
someone puts your DB on his server, he can use his sysdba privs.
See the Language Reference and the Data Definition Guide. See also CREATE
ROLE, as roles are a way to reduce the amount of privilege-granting you
have to do.
heLen
>Where can I find out how I can set SQL priveledges, so that I the creatorThe good news is that this is the default. Privileges in a Firebird
>of the table has all privileges and everybody else has none. So that even
>when they connect to my database file that they can do nothing not even run
>a SELECT statement.
database are "opt-in" - every user except sysdba and Owner must be granted
privs to get any access. You can't prevent sysdba access anywhere, so if
someone puts your DB on his server, he can use his sysdba privs.
See the Language Reference and the Data Definition Guide. See also CREATE
ROLE, as roles are a way to reduce the amount of privilege-granting you
have to do.
heLen