[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

i need to grant a privs to a role, it will be granted automatically to all users who have this role

Hi guys,

I need to grant some privs to a role, it will be granted automatically to all users who have this role or I have to grant individually.
0
nirvairghuman
Asked:
nirvairghuman
  • 3
  • 2
5 Solutions
 
sdstuberCommented:
any existing sessions will not be affected by the change.

the next time the users login the changes to their roles will apply
0
 
slightwv (䄆 Netminder) Commented:
Yes unless stored procedures that do DDL are involved.  They might need to log off and back in before the privs are available.

0
 
slightwv (䄆 Netminder) Commented:
Yes unless stored procedures that do DDL are involved.  They might need to log off and back in before the privs are available.

0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
nirvairghumanAuthor Commented:
I can just grant  to role and I have to grant individually to each user.
0
 
slightwv (䄆 Netminder) Commented:
Whatever you grant to the role will be granted to any user with that role on next login with the exception noted above.
0
 
sdstuberCommented:
each user will need to have the role granted to them,  but once that is granted,  you can update just the role
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now