Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread How i can use DB operator in a big application ?
Mon, Oct 6 2008 12:14 PMPermanent Link

"Mauro Botta"
hi

How i can use DB operator in a big application ?

1)  For a normal use , Must i use standard "Administrator" user o must to
create a new "MYUSER" ?


2) there are external people , open my db for 3'party program ( via odbc) ,
witch type of user  ?
Tue, Oct 7 2008 1:38 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mauro,

<< How i can use DB operator in a big application ?

1)  For a normal use , Must i use standard "Administrator" user o must to
create a new "MYUSER" ? >>

No, it is your choice - you can have everyone use the Administrator login,
or you can create separate roles and users for all users on the system.

<< 2) there are external people , open my db for 3'party program ( via odbc)
, witch type of user  ?  >>

You can set it up anyway that you wish.  For a primer on the user security,
please see here:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=8

If you only want ODBC users to read the data, but not update it, then you
can define a role called 'ODBC' that will only allow reading (SELECT)
privileges on the database, and then you simply assign users to this role
via the GRANT ROLE statement in order to allow them to have these
privileges.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image