database-permissions
PostgreSQL user groups and authorization
Postgresql version 9.0 I need an idea for grouping postgresql users. i have 150+ table in database, and i want to settle groups of people. some of them can reach all tables, some of them not.[详细]
2023-04-08 12:06 分类:问答How to manage user/permissions in an environment web/PL/SQL correctly?
My team will develop an internal (known users) application that has an architecture based on Java as front-end and PL/SQL as back-end. So, currently we are thinking in a better solution to manage the[详细]
2023-04-05 19:00 分类:问答SQL Server Disabling All Triggers - Cannot find the object "XXXX" because it does not exist or you do not have permissions
I\'m trying to run this command in SQL Server: disable trigger all on MYDB This is failing for me.The account I\'m logged into has access to MYDB and I\'ve pretty much giving it every single permis[详细]
2023-03-30 16:17 分类:问答Entity Framework : Relational Model help for Permissions, Users etc
Can anyone help? I am looking to create a good relational model for managing Permissions. I currently have a Users table, and various other tables like Customers, Suppliers.[详细]
2023-03-28 04:39 分类:问答Applying least privilege to database connections
I\'ve noticed that most FOSS applications (Wordpress, for example) only uses a single set of database credentials that have been granted all permissions. This seems like it violates the principle of l[详细]
2023-03-23 07:24 分类:问答Permission Issue for SQL Server 2008 Stored Procedure Using Encryption
I have arranged a database with three schemas. U开发者_StackOverflownder Database User, I have ticked the three schemas as Owned Schemas of the user I\'m connecting via (thought it was a good idea at[详细]
2023-03-18 11:53 分类:问答SQL Server revoking select
Let\'s suppose a user, \"Bob\", gets SELECT privilege from John and Bob also get开发者_开发问答s SELECT privilege from another user Joe but this time with GRANT option.[详细]
2023-03-17 06:31 分类:问答How to create a user with readonly privileges for all databases in Postgresql?
I want to create a user with only select privilege for all tables in all开发者_C百科 databases. I thought that I could get a list of databases and apply the following command for each database:[详细]
2023-03-14 17:49 分类:问答classic asp recordset permissions problem
I\'m trying to return 开发者_开发技巧values of a specific column using the below sql string, If I change it out to sql = \"select * from a_page\" and objRS(\"P_description\") it returns the values but[详细]
2023-03-14 09:24 分类:问答Deny access to the user to alter any table or relationship in sql server
how to deny acces to a specific user in the database to alter any tables or columns or relationships ona sql server database.is it possible, if we deny alter access of \'schema\' to the user[详细]
2023-03-14 06:03 分类:问答