Hi--

Seems simple enough i shouldn't need to ask BUT i can't get it to work

i have a database created and access on Firebird for years.

i've always used the id/pw sysdba/masterkey

all i want to do is:

change my delphi IBO Objects tIBConnection.username to 'mynewuser'

and .password to 'mynewpassword'

i am not sure what to use in .SQLROLE?  i've tried 'RDB$ADMIN'  and leaving it blank 

on the computer with the database? using gsec i've run:

gsec -user sysdba -pass masterkey -add mynewuser-pw mynewpassword -admin yes

now, when i try and connect the TIB_Connection, i get this error message:

"could not open tableA table

isc error code 335544352

no permission for read/select access to table tableA"

no surprise, i've got a customer that doesn't want to use the sysdba/masterkey connection id/pw 

so all i'm trying to do is add a new one...

i've google the heck outta this and can't figure it out.

what am i missing? 

thanks in advance