Subject | Re: sysdba versus other user |
---|---|
Author | Adam |
Post date | 2005-05-02T00:20:58Z |
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:
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) ?backup
>
> 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,
> > andand
> > > > restore the database. The owner will also be able to backup
> > > restore itsinstallation -
> > > > 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
> > > which answers my flipside question about where these useridsare stored.
> > > My reading is that there is a server specific database for allthe
> > > userids no matter how many application databases there might be.the
> > > Permissions and rights to objects in any database are stored in
> > > server's own private database. This was really a question not aservices API
> > > statement :) ??
> > >
> > > Mike
> > >
> >
> > yes. It's called security.fdb. It's not that private. the
> > willthe SYSDBA
> > tell you where exactly it is on any server, as long as you know
> > password.Worboys on the
> > You cannot change the userid SYSDBA to anything else.
> > Maybe you should read the metadata/security paper by Geoff
> > firebordSQL website.
> >
> > Alan
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]