Subject | Re: [firebird-support] Setting SQL privileges |
---|---|
Author | Uwe Oeder |
Post date | 2003-11-25T07:36:16Z |
What would happen when I am a sysdba and then create the database file.
Will other sysdba's have access to the file ?
At 08:51 AM 11/25/2003, you wrote:
Will other sysdba's have access to the file ?
At 08:51 AM 11/25/2003, you wrote:
>At 08:51 AM 25/11/2003 +0200, you wrote:
> >Where can I find out how I can set SQL priveledges, so that I the creator
> >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.
>
>The good news is that this is the default. Privileges in a Firebird
>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
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/