database-permissions Questions
4
Solved
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 permi...
Acciaccatura asked 24/8, 2011 at 14:0
4
Solved
I'm trying to create a Postgres database for the first time.
I assigned basic read-only permissions to the DB role that must access the database from my PHP scripts, and I have a curiosity: If I ex...
Tepper asked 27/6, 2013 at 8:46
2
Solved
I want to create an immutable Postgres database, where the user can insert & select (write & read) data, but cannot update or delete the data.
I am aware of the FOR UPDATE lock, but I don't...
Warwick asked 18/3, 2019 at 19:59
2
Solved
I've tried using the documentation here but doesn't seem to help. If you can please give me an example.
revoke select (column1, column2) on table from specific_user
hasn't worked.
Access privil...
Indurate asked 18/1, 2018 at 9:27
7
Solved
I want to create a user with only select privilege for all tables in all databases. I thought that I could get a list of databases and apply the following command for each database:
GRANT select O...
Antagonistic asked 23/6, 2011 at 10:59
9
Solved
My ASP.NET v3.5 web application is throwing the following exception when it attempts to open a connection to a SQL Server 2008 database:
System.Data.SqlClient.SqlException:
Cannot open database &q...
Erasmo asked 13/8, 2009 at 2:16
8
Solved
After this comment to one of my questions, I'm thinking if it is better using one database with X schemas or vice versa.
I'm developing a web application where, when people register, I create...
Cypress asked 20/7, 2009 at 8:45
3
Currently I am using this to grant permissions:
grant select on all tables in schema public to <user_name>;
alter default privileges in schema public grant select on tables to <user_name...
Alveraalverez asked 11/10, 2013 at 2:42
3
Solved
I'm using ASP.NET MVC 4 - c# to connect to a live database, and list the results, however when I go to view the page it returns the following error:
CREATE TABLE permission denied in database 'Dat...
Contravention asked 6/2, 2013 at 11:0
2
Solved
I have logged into my database as the database owner (a superuser as well) and have created a role_write role with nologin and noinherit flags.
I've revoked the default create permissions from the ...
Weathers asked 28/4, 2019 at 15:53
2
Solved
Is it possible to copy the user permissions from one table in a PostgreSQL database to another table? Is it just a matter of updating the pg_class.relacl column value for the target table to the va...
Umbrage asked 30/11, 2009 at 22:18
1
Solved
I am attempting to drop a role and have severed all ties to it that I can locate, but there is one lingering issue I cannot resolve. When I run this:
drop role hank
It tells me:
ERROR: role "ha...
Statant asked 7/1, 2019 at 14:19
3
Solved
Short version: How can I write an SQL procedure to list which of several tables in a MySQL database a particular user has access to?
Longer version:
I'm writing a multi-user app that accesses a d...
Gremial asked 17/2, 2011 at 3:7
3
Solved
Suppose a user has full read/write access to MySQL database. Is there any way (some parameter in connection string) to connect to database by the same username and password in read-only mode?
I wan...
Sanctimonious asked 20/4, 2012 at 5:44
4
I have a bit of a funny situation in Amazon Redshift where I have a user X who has grant select on all tables in schema public, but once a new table is created, this grant doesn't seem to apply to ...
Unavailing asked 3/2, 2016 at 22:20
1
Solved
I want to perform some dynamic DDL in a procedure owned by an admin user. I'd like to execute this procedure with a technical operational user with definer rights (operational user doesn't have the...
Ci asked 31/7, 2017 at 9:18
4
Solved
I'd like to know how to set up permissions within SQL Server to allow my application Login/Role to be able to send email using msdb.dbo.sp_send_dbmail.
I have a database MyDb, a user MyUser who is...
Filomena asked 6/4, 2011 at 16:4
7
Solved
In testing, the user on a db i've used was a big jefe. In production, he only has Execute.
When I called,
Membership.DeleteUser(user)
In testing, it worked.
I try the same in production, and I ...
Federicofedirko asked 23/1, 2009 at 14:26
3
Solved
Could you please advise, what are permissions required to give user access to read Database diagrams in SQL Server 2005?
Thanks a lot!
Dunkirk asked 11/1, 2011 at 18:42
5
Solved
This question was originally using MySQL 5.1.44, but is applicable to MySQL 8.0+ too.
Let's say I have a table with records inserted by different users of my application. How can I give a specific ...
Loreanloredana asked 24/6, 2010 at 9:24
1
Solved
I can't find why I am getting an permission denied error in my database.
The role owns the schema and has access to the table, but still the log says:
ERROR: permission denied for schema myschema...
Jewett asked 13/2, 2015 at 15:52
2
My head is bloody from how hard I've been banging it against this wall for the past several hours. :(
As the title suggests, I've created a MySQL user that can access the database fine from the my...
Renaissance asked 15/9, 2012 at 7:27
5
Solved
What permission do I need to GRANT a user, in MSSQL, in order to be able to truncate a table?
I'm trying to grant the minimal set of permissions, but I can't use DELETE, because the table is very ...
Omarr asked 19/1, 2011 at 12:8
1
I want to create a user with permission to create and drop views but not drop tables or databases. This is so I can play around when testing my views without the risk of accidentally deleting a tab...
Densify asked 9/7, 2013 at 10:40
1
I created a read-only user in PostgreSQL and it is still able to create tables:
I created a test DB and then created a readonly2 user. Gave it only select privileges on 2 tables. When I log into t...
Reexamine asked 20/6, 2014 at 17:24
1 Next >
© 2022 - 2025 — McMap. All rights reserved.