Questions tagged [permissions]
Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
1,605
questions
1
vote
1
answer
45
views
Need to add user and assign roles automatically, using DDL Trigger, when database is created
I am trying to create an automated process that will add a user and assign them the roles of db_datareader, db_datawriter and db_ddladmin whenever a database starting with PA is created. I have ...
0
votes
1
answer
21
views
Same global user works local but fails on live server for information_schema database UPDATE query
I have two database servers, local and live.
The local server is running MariaDB 10.11.6, the live server is running 10.11.8.
I have the exact same global user, example@localhost on both the local and ...
-1
votes
1
answer
33
views
SQL Server Management Studio "Key cannot be null" error when giving a specific user permissions on Stored Procedures
I'm attempting to give a specific user execute permissions on a Stored Procedure. When I attempt to do so, I get an error:
Key cannot be null. Parameter name: key (System)"
When I attempt to ...
0
votes
0
answers
18
views
MS sqlserver user grant access
I have a huge problem with rights of new users of my SQL Server database. The new user can access all tables irrespective of grant access
code to create login and user
USE [master]
GO
CREATE LOGIN [...
-3
votes
0
answers
12
views
no COPY permission with CSV
i read all post with denied permission problem. But I need a COPY in script (python psycopg2), I can't use psql \copy
I'm on MX-LINUX, postgresql 15. My role is superuser, i'm DBA of my database, I ...
1
vote
2
answers
106
views
error when re-applying the permissions script into the original database - sql server
when I run the following script:
-- ——— SCRIPT GRANTS for Object Privileges—————
IF OBJECT_ID('[sys].[sysrowsets]') IS NOT NULL GRANT CONTROL on [sys].[sysrowsets] to [db_myrole_BA]
I get this ...
-1
votes
0
answers
10
views
why pgAdmin4 Tablespace Security privileges does not count for pg_default if no tablespace is selected when creating new database? how to solve this?
why pgAdmin4 Tablespace Security privileges does not count for pg_default if no tablespace is selected when creating new database? how to solve this issue?
Hy all
-I have a server dedicated to ...
0
votes
2
answers
51
views
How do I prevent a DB user to change table contents in SQL Server?
How do I specify that a DB user cannot edit the AspNetUserRoles table in SQL Server? Currently, the user has Membership->db_owner permission, and it can do everything.
I would like to control ...
0
votes
1
answer
32
views
How can I allow a user to alter tables they do not own in Postgres?
I need to be able to assign a role to users to allow them to do anything they want to tables in a schema. I need to do this without assigning superuser priv in Postgres.
I already figured out how to ...
0
votes
0
answers
60
views
Permission denied to ALTER DEFAULT PRIVILEGES
I'm trying to alter the default privileges of a role (roleB) that I am a member of, to allow it to modify objects created by another role (roleA) that I am also a member of.
I have the inherit ...
1
vote
1
answer
29
views
PostgreSQL crosstab query not using view owner permission when queried from other users
I'd like some help with regards to creating a view in PostgreSQL using the crosstab function.
I've been trying to create a view as follows:
create or replace view csv_data as with answers as(
select * ...
0
votes
1
answer
29
views
PostgreSQL: permission denied to COPY to or from an external program, even after Grant pg_execute_server_program
Running Copy test(id, name) From Program 'zcat /tmp/test.csv.gz' CSV Header; fails with:
SQL Error [42501]: ERROR: permission denied to COPY to or from an external program
Detail: Only roles with ...
0
votes
1
answer
75
views
Checking REFERENCES permission is granted or not?
I am trying to execute the following minimalized example on SQL Server (14.0.3465.1):
--drop TABLE [dbo].[testtable]
--drop TABLE [dbo].[referencetable]
create table [dbo].[referencetable](
[...
0
votes
0
answers
8
views
CREATE TABLE permissions required to append Pyspark dataframe to SSMS table
I am using AWS glue to extract some data from RDS, parse it into some other format and push it back to RDS.
The RDS user I use has SELECT and INSERT permissions on tic.Example. However, when I try to ...
0
votes
0
answers
64
views
How to prevent user from connecting via SSMS but allow query via .net application connectionstring?
I have been given task to create a SQL login that can be used to query the db via a .net application connection string.
But the user shouldn't be able to connect to SQL via SSMS.
I have created the ...