Subject Re: [firebird-support] Read only user
Author Gustavo
Post date 2007-10-30T00:07:14Z
If I don't grant EXECUTE, anyway the user will be allowed to execute a SP
inside a SELECT?

Gustavo

----- Original Message -----
From: "eMeL" <emel@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, October 29, 2007 8:36 PM
Subject: Re: [firebird-support] Read only user


>
>> I need to create a user wich has
>> read only privileges to every table in every database.
>
> ... and because select can modify database (for example if execute SP)
> you may start read only transactions for this user.
>
> eMeL
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>
>
>
> __________ InformaciĆ³n de NOD32, revisiĆ³n 2625 (20071030) __________
>
> Este mensaje ha sido analizado con NOD32 antivirus system
> http://www.nod32.com
>
>