At 04:00 AM 31-05-02 +0000, you wrote:

>How is this done, Aage?
>
>--- In ib-support@y..., Aage Johansen <aagjohan@o...> wrote:
> > semprolbat wrote:
> > > Is there some way to prevent standard users from running "show
> > > procedure xxx;" or similar?
> > > I don't want reveal any business logic...
> >
> > You can delete the source text of SP's and triggers.

UPDATE RDB$TRIGGERS SET RDB$TRIGGER_SOURCE = NULL
WHERE ....

UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL
WHERE ...

Good idea to have your documentation in good order before doing this. :))

heLen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________