Subject RE: [firebird-support] How to create user & assign rights
Author Alan McDonald
>
> 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.
>

GRANT ALL ON CUSTOMER TO TEST;

Alan