Questions tagged [permissions]

Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.

Various systems, including database management systems, must be able to provide security that prevents unauthorised access or modification of data. Security mechanisms grant permissions to users or roles (groupings of users) that allow or restrict sessions with those credentials from doing certain actions.

Allowable actions that may be controlled by the security system include insert or read permissions on tables, permissions to alter the structure of the database, execute stored procedures, or carry out certain administrative tasks.

'Permissions' typically refers to the set of allowable actions that a given login or role may perform based on the access configured for that role in the systems security manager.

1584 questions
1
vote
0 answers

Pros and cons of setting super admin in users table

I'm structuring a RBAC in a Web system. My database tables looks like: actions id name resources id name permissions id action_id resource_id roles id name permission_role permission_id role_id users id role_id is_super_admin The roles…
0
votes
1 answer

Maximum granularity of user permissions (certain rows within table?)

Our current system architecture is fairly simple. There's a global list of devices, which move between gateways. The idea is such that the global list of devices is stored in one table, such that any gateway can read the information about any…
user27989
  • 3
  • 2
0
votes
1 answer

MS SQL - Minimum Permissions to View Sensitivity Classifications

I'd like to provide some user groups access to view Sensitivity Classifications. Currently it returns blank results in the reports tool, or directly querying sys.sensitivity_classifications table. What's the minimum permission set, default or…
mcswiggen
  • 3
  • 1
0
votes
0 answers

Schedule group disable write - with custom error

I'm looking for a good solution to what seems to be a simple problem. I need to disable a user group from writing to any number of tables on a schedule - let say Saturday between 0600 and 1200. I'd like not to have to write special time handling…
SmittyBoy
  • 101
0
votes
1 answer

vCenter 7 postgres ERROR: permission denied for view vpxv_hosts

We just upgraded this VCenter server to this version, actually 2 of them and they are both giving this error. We have tried the GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA vc to our_user command and it did not help. Everytime we run the "grant…