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.
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
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
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.
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
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
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.
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:
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
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