I am using SQL Navigator 5.5 Standard Edt.
Recently, i Granted RESOURCE role to one of our users. After granting that role, i decided to revoke it from the user and just give the user the CONNECT role.
This is how I went about revoking the role from the user:
- Right click on the User name under USERS (DB Navigator view - F12).
- Select Open
- Click on the Roles Tab
- Under Granted Roles Heading, unchecked the RESOURCE Role.
Guess what happened, SQL Navigator actually removed the RESOURCE role itself.
I wondering why would it happen like that.
I just wanted to revoke the Resource role from that particular user ONLY.
Can someone shed some light on this?
Thanks a lot,