We have a role Rcreated. This role is granted to INSERT and UPDATE on all tables. I have mapped 20 users to this role R Now these 20 users have got the INSERT and UPDATE permission as the role is granted. But now I wanted to DENY INSERT permission for one

[Eli]

Hello everyone, I would like to ask you a little question for those who do medicine, we have a role rcreated. this role is granted to insert and update on all tables. i have mapped 20 users to this role r now these 20 users have got the insert and update permission as the role is granted. but now i wanted to deny insert permission for one of those 20 users. is it possible without detaching that user from the role r1? Please give me a reply please by return message.