| Subject | How to create user & assign rights |
|---|---|
| Author | Harish |
| Post date | 2010-05-18T05:33Z |
1. I created a new database on my server with SYSDBA. Database Name
is Test.fdb
2. I also created a table which I can access using SYSDBA.
3. I Created a User using GSEC. User : TEST. password : test
4. I am able to connect to the database Test.fdb with user TEST & password test. But when ever I try to execute a SELECT query on any of the table, i get the followig message.
"no permission for read/select access to TABLE CUSTOMER" ...
What can I do, can anybody help me.
is Test.fdb
2. I also created a table which I can access using SYSDBA.
3. I Created a User using GSEC. User : TEST. password : test
4. I am able to connect to the database Test.fdb with user TEST & password test. But when ever I try to execute a SELECT query on any of the table, i get the followig message.
"no permission for read/select access to TABLE CUSTOMER" ...
What can I do, can anybody help me.