Question : what permissions do I need to give in order to achieve the above task to get users the […]
Tag: role
How do I detect execute permission granted to a role (when no ON clause was used)
Question : I just spent hours trying to figure out how an app had privilege to execute stored procedures. TIL […]
Comma List vs Multiple Records
Question : I am currently building out an application that will contain many users, two roles and two groups. Logically […]
Are there any tables that I can get all Oracle supported system privileges and object privileges?
Question : Are there any tables that I can get all Oracle supported system privileges and object privileges? I know […]
Scripting an application role with a hashed password
Question : I need to script an application role with a hashed password, so I can copy it from one […]
Is it possible to set PostgreSQL roles with privileges this way?
Question : I’m trying to develop a system, and for the first time I’m using PostgreSQL. I’m trying to organize […]
Locating a schema that owns a role
Question : Let’s say we’ve logged on under the A schema. I am able to execute the following statement grant […]
When creating views, why do users need direct object permissions if they already have the same permissions via a role?
Question : I’m having a problem with permissions in Oracle 10g. I’m hoping someone can help me make sense of […]
How do I assign an entire Active Directory group security access in SQL Server 2008?
Question : I would like to use integrated security with my internal application which is all on a domain. Unfortunately, […]
Oracle: how to set only some roles as not default for a user (no GUI)
Question : Scenario: I have instanceA I have instanceB I have USER1 in instanceA I have USER1 in instanceB USER1 […]