Subject | RE: [firebird-support] Re: Can we "Lock Down" Firebird to keep users from tampering with data? |
---|---|
Author | Chris Donges |
Post date | 2006-03-13T22:09:19Z |
How do you remove that role?
> -----Original Message-----
> From: Alexandre Benson Smith [mailto:iblist@...]
> Sent: Tuesday, 14 March 2006 8:05 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Re: Can we "Lock Down"
> Firebird to keep users from tampering with data?
>
> dbagregc wrote:
> >
> > I tried to create a role called sysdba and it would not let
> me do it.
> > It says "This operation is not defined for system tables.
> > unsuccessful metadata update. user name SYSDBA could not
> be used for
> > SQL role." The steps I took were to log on as sysdba, create a new
> > user, log on as the new user, then tried to create role
> called sysdba.
> > Any suggestions?
> >
> I think it should be:
>
> Log as SYSDBA
> create the SYSDBA role
> logout
> try to log as SYSDBA (should fail)
>
> never tried it, but I think that should be this way.
>
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>