|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Using Roles and Users
Hi to all,
In a database I create the role READ and I did this: CREATE ROLE read; GRANT SELECT ON table1 TO read; GRANT read TO user1, user2, user3; then I access to the database like user1 an I wanna do this: select * from table1 but I have this excetion: The user does not have the privilege to permorm this operation on this object. no pertmition for read/select access column Nro_completato why? What's wrong? thank's boss |
|
#2
|
|||
|
|||
|
Check the followings:
1. read is a keyword. Maybe you should use "READ". 2. when u logged on with user1, did you log on with Role: read? |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Using Roles and Users |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|