Add the ability to specify default role during CREATE / ALTER USER [CORE4414] #4736
Comments
Modified by: Sean Leyne (seanleyne)description: Add the ability to specify a default role for deals CREATE / ALTER USER. CREATE USER TEST PASSWORD 'test' DEFAULT ROLE MYROLE; ALTER USER TEST SET DEFAULT ROLE RDB $ ADMIN; This feature is present in such interbase 7.5 and above. However, this does not negate the need for a rights group as an alternative roles. => Add the ability to specify a default role for deals CREATE / ALTER USER. CREATE USER TEST PASSWORD 'test' DEFAULT ROLE MYROLE; ALTER USER TEST SET DEFAULT ROLE RDB$ADMIN; This feature is present in such interbase 7.5 and above. However, this does not negate the need for a rights group as an alternative roles. summary: Add the ability to specify a default role for deals CREATE / ALTER USER => Add the ability to specify default role during CREATE / ALTER USER |
|
Commented by: Sean Leyne (seanleyne) How does this work (in IB) when a Role is defined/passed when opening new connection? |
|
Commented by: @sim1984 If a connection role is not specified, it is taken that contains the user by default. If a connection is used specifies the role that she and not the default role. I did not check how it works in IB, this is just my thoughts on how it should work. |
Submitted by: @sim1984
Votes: 1
Add the ability to specify a default role for deals CREATE / ALTER USER.
CREATE USER TEST PASSWORD 'test' DEFAULT ROLE MYROLE;
ALTER USER TEST SET DEFAULT ROLE RDB$ADMIN;
This feature is present in such interbase 7.5 and above.
This does not contradict the principles of roles, as in the sentence given only one role. This feature combines well with the recently introduced the ability to change roles without reconnecting CORE1377.
However, this does not negate the need for a rights group as an alternative roles.
The text was updated successfully, but these errors were encountered: