Subject | RE: [firebird-support] How to create user & assign rights |
---|---|
Author | Alan McDonald |
Post date | 2010-05-18T06:47:07Z |
>GRANT ALL ON CUSTOMER TO TEST;
> 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.
>
Alan