Hi adnoctum13

I don't know about a place where you can get the list of environment
variables (did you check the manuals?), but you can get what you need in
your example by using current_user: select current_user from rdb$database
(another variables could be current_date, current_time).

I think that you can protect your metadata from users using Interbase 6.5.
In Firebird (and in Interbase versions 6 and before) you can't, but you can
delete the source by using something like:

update rdb$procedures
set rdb$procedure_source=null
where ((rdb$system_flag=0) or (rdb$system_flag is null))

This will delete your source (your DML code) from the database, but will not
delete the associate BLR code (the compiled version of your code). Of
course, you don't be able to see it also, so you must keep the source
somewhere.

Artur Trindade Anjos
Firebird' it !
http://www.comunidade-firebird.org

----- Original Message -----
From: "adnoctum13" <adnoctum13@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, October 11, 2002 9:41 PM
Subject: [ib-support] Environment variables


> Hi,
>
> I'm new to Interbase and it's costing me some troubles adjusting. I
> come from SQL Server and im used to read environment variables like
> this 'select user' to see what's the current user's login.
>
> What environment variables are defined in interbase?
>
> Also, Can I encrypt my procedures and udf's? I wouldn't realese the
> source code of my procedures to my clients.
>
> Thans to all.
>