GeekGirlau
Programmer
I've made the erroneous assumption that when you create a new user in a secure database and add them to specific groups, they inherit all the permissions for those groups. However what I'm finding is that the user doesn't automatically have permission to open the database object, even if they belong to groups that do.
Is this correct? Do I need to manually set the permissions for each individual user after assigning them to groups? Do I need to set the permission for only the database object, or for all existing objects within the database?
I need to set up several secure databases to be able to be maintained by non-programmers, so I need to give certain users the ability to create new users with as little human intervention as possible.
Is this correct? Do I need to manually set the permissions for each individual user after assigning them to groups? Do I need to set the permission for only the database object, or for all existing objects within the database?
I need to set up several secure databases to be able to be maintained by non-programmers, so I need to give certain users the ability to create new users with as little human intervention as possible.