Subject Re: sysdba versus other user
Author Adam
lol, you are going to have trouble finding it on the firebord site :)

The direct link is here:

http://www.firebirdsql.org/index.php?
op=doc&sub=contrib&id=fb_meta_security

Bookmark the article. Worth the read.

Or you can just browse the FAQ to question 20

http://www.firebirdsql.org/index.php?op=faq#q0020.dat

Adam

--- In firebird-support@yahoogroups.com, Patrick Antonioli
<patrick.antonioli@g...> wrote:
> What is the url from this site (firebordSQL) ?
>
> Patrick
>
> 2005/5/1, Alan McDonald <alan@m...>:
> >
> > > Objects inside the database can be owned by yet
> > > > other users if you wish.
> > > > But at all times, SYSDBA will be able to access all objects,
backup
> > and
> > > > restore the database. The owner will also be able to backup
and
> > > restore its
> > > > database but this non-SYSDBA identity will not be able to
> > > backup a database
> > > > for which it is not the owner.
> > >
> > > And - I just read in TFB that SYSDBA is created upon
installation -
> > > which answers my flipside question about where these userids
are stored.
> > > My reading is that there is a server specific database for all
the
> > > userids no matter how many application databases there might be.
> > > Permissions and rights to objects in any database are stored in
the
> > > server's own private database. This was really a question not a
> > > statement :) ??
> > >
> > > Mike
> > >
> >
> > yes. It's called security.fdb. It's not that private. the
services API
> > will
> > tell you where exactly it is on any server, as long as you know
the SYSDBA
> > password.
> > You cannot change the userid SYSDBA to anything else.
> > Maybe you should read the metadata/security paper by Geoff
Worboys on the
> > firebordSQL website.
> >
> > Alan
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]