Subject | Re: [Firebird-general] error: no priveledge to TABLE IBE$SCHEMA_BD |
---|---|
Author | Helen Borrie |
Post date | 2005-04-12T14:35:11Z |
Bob - please would you stop posting support messages to this list? You
should subscribe to firebird-support and post there.
Others - please feel free to follow him through to the support list but
refrain from letting this evolve into a thread here.
^Helen
At 02:27 PM 12/04/2005 +0000, you wrote:
should subscribe to firebird-support and post there.
Others - please feel free to follow him through to the support list but
refrain from letting this evolve into a thread here.
^Helen
At 02:27 PM 12/04/2005 +0000, you wrote:
>I was playing with privledges and got clobbered. Removed all
>priledges for a user and them restored "ALL" privledges. Opened my DB
>and got a message box with "error: no permission for read/write
>access to TABLE IBE$SCHEMA". Also got this for a new user added with
>ALL privledges. I found an INTERNET post with something similar and
>solved the problem by: ( Using IBEasy+ )
> 1. Opened the DB as SYSDBA and opened Tools/SQL Expert Mode
>
> 2. Entered "grant select on IBE$SCHEMA_BD to user BOB ;" also
>for MIKE
>
> 3. Clicked the execute icon ( ! )
>
> 4. Logged off as SYSDBA and back on as BOB ( or MIKE ) and
>walla message is gone.
>
>The error message went away. I hope I didn't hurt anything else.
>The post I found on the web indicated that this is a bug in Firebird.
>
>Any comments??
>
>
>
>
>
>
>
>Community email addresses:
> Post message: Firebird-general@yahoogroups.com
> Subscribe: Firebird-general-subscribe@yahoogroups.com
> Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
> List owner: Firebird-general-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/Firebird-general
>Yahoo! Groups Links
>
>
>
>