Devart Forums

Hello
I have created a role granting right to a table
I have assigned to a user this role
however when I login using this user I have no right to look at the data

there is no role in the login form (which would defy the purpose)
What am i doing wrong ????
thanks
PW

Hello,

To solve the problem, you should set the TIBCConnection.Options.Role property to the role name that you granted to a user.

Thank you
But how do I know what role has what user???

that the whole idea of user security you define roles and assign user to them
so when a user logs in knowing its roles we know its privileges. no need to grant for each user just a few roles

Why does the default login form has no field for roles then ????

Thanks
PW

You can assign many roles to one user, therefore you should give each user the name of the role that must be used. For the time being our ConnectDialog doesn't have the functionality that allows using role names. To avoid this problem, you can write your own connection form. Please take a look at the example of such connection form in the IBDACDemo->ConnectDialog demo.

@PW: You can query the system tables to get a list of roles a particular user is a member of.