[firebird-support] connecting to an existing firebird database using new user id/pw

 

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

__._,_.___

---

Posted by: avert@telusplanet.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___