One recommendation is to create an authorization group and add the serv er login name (DBEUserID) to the group. Be sure to gran t all the desired authorizations to this group. Give the name of the group to the application users and dev elopers on the remote clien t.

Encourage them to use this group as the o wnership quali￿er when accessing and creating SQL objects that they o wn.

ALLBASE/SQL Application Programmers

If you are an application programmer on the clien t, you should design y our programs so that the data they are accessing can be mo ved to a remote node without causing c hanges to the programs. Here are some programming recommendations:

Do not assume that the DBEUserID is based on the clien t login name. In a remote access con￿guration using ALLBASE/NET, the DBEUserID is based on the serv er login name. The server login name need not be the same as the clien t login name. Therefore, do not fully qualify an unquali￿ed object's o wner with the clien t's login name. For example, if an end user types the command select * from tablename , pass the tablename directly to ALLBASE/SQL without pre￿xing the table name with the clien t's login name. ALLBASE/SQL resolv es unquali￿ed object o wners.

When preprocessing programs remotely , qualify the module o wner to be the server login name (DBEUserID) or a group name to whic h the server login name belongs. This is done b y using the -o option in the preprocessor command. F or example:

psqlpas sampledb -i sample.sql -o serverlogin -d

ALLBASE/SQL Application Users

If you are a user of an application program, do not assume that the DBEUserID is based on the client login name. In a remote access con￿guration using ALLBASE/NET, the DBEUserID is based on the serv er login name. The serv er login name need not be the same as the client login name. Therefore, do not fully qualify an unquali￿ed object's o wner with the client's login name. Talk to your database administrator about possibly creating a group with your server login as a mem ber. The group can be used to fully qualify ALLBASE/SQL objects.

Some existing programs, suc h as ALLBASE/Query, may incorrectly assume that the clien t and server login names are the same. If that is the case, remote access using ALLBASE/NET may have restricted functionalit y unless the serv er login name can be made the same as the client login name, or the application is rewritten using the recommendations made abo ve for application programmers.

Getting Started 1-7