Hi

i have need to add to 2' user at my DB for read only access.

i have create a new user.   OK
i have create a new Roles "ReadOnly".  OK
i have checked only "SELECT" value for ReadOnly Roles.  OK
i have grant this new Role at new User. OK

Assign permission at one table..

GRANT SELECT
ON TABLE "MyTable001"
TO "ReadOnly"

all ok.


but if try to open this table , i can't.

1) i have modify EDBManger session with this new Login / password

and i can't open the session.

Error : ElevateDV Error #401 The database Configuration dose not Exist.


2) then.... i have open Delphi 2009 ,  new application , drop
Engine,Database,Session,EDBTble.

enter administrator L/PWD , all work fine , All Table is viewed in
EDBTable.TableName property.

if i enter new limited user  L/PWD , don't worke , Combo of
EDBTable.TableName property is Empty.

i can't use this new user


I need any Hint  

Mauro,

<< 1) i have modify EDBManger session with this new Login / password

and i can't open the session.

Error : ElevateDV Error #401 The database Configuration dose not Exist. >>

You need to do this:

1) Make sure that the new user is granted the Public role (required for
access to the system-defined Configuration database).

2) Make sure that the Public role does not have read/write permissions to
the table(s) that you wish to restrict access to.

--
Tim Young
Elevate Software
www.elevatesoft.com