Questions tagged [permissions]

Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.

Filter by
Sorted by
Tagged with
0
votes
1answer
38 views

How to deny viewing definition of server level trigger?

I have several server level triggers, that I want users to deny viewing definition of. I control server level permissions, users aren't sysadmins etc. I've tried 2 options: DENY VIEW ANY DEFINITION ...
0
votes
0answers
7 views

Storing table(s) outside data-dir symbolic-links/tablespace

Because my only internal harddisk is running low on space, I decided that I want to store the tables for a specific database large-database on an external SSD drive. Trying to setup the configuration ...
0
votes
1answer
24 views

Postgresql: Permission denied to schema to user created based on master with rights

I'm trying to write a function that eventually will rotate users. Currently I have the code below which works and creates a new user using the prior user which ultimately has the same rights as the ...
-1
votes
1answer
9 views

Query Oracle Database On Who Has Create Database Link Privs (private)?

Anybody know a good way to query the entire Oracle database on what users have privs to make private database links? Thank you!!
0
votes
1answer
18 views

Can Postgres restrict usage of the SET and SHOW commands?

Is it possible to restrict a role from being able to set arbitrary session variables, or from being able to view them? select current_setting('x'); show x; Even after I've switched roles to a one ...
0
votes
0answers
17 views

Grant select on all the tables in HSQLDB

I want to grant select privilege to all the tables in my HSQLDB. I have gone the HSQLDB documentation there I found to grant select on only one table. How can I grant select on all the tables.
0
votes
2answers
49 views

Cannot login as new user on MariaDB

When I create a new user in MariaDB, I cannot login as that user. First I login to the database as root doing mariadb in a bash terminal. I then run the following commands to create a database and ...
0
votes
1answer
36 views

What permissions does the SQL Agent's user need to execute Powershell scripts?

I'm trying to create a job with a Powershell step. To recreate this: create new job, give it a name add a new job step, name it, type powershell, run as the SQL Agent, script: $test="test" set the ...
0
votes
0answers
19 views

PostgreSQL trigger for user access on creation of new schema or table

I'm looking to create a trigger which will grant group access to both a schema or a table when created within a database. Admittedly I might have this wrong and it may be done through a different ...
0
votes
2answers
38 views

Why can't I create a MySQL user even if i have 'all priviliges'?

I am trying to resolve issues created when my ISP moved my database from a shared server to dedicated cloud storage. I am reaching it remotely via SQLyog. They say they have given all privileges to ...
0
votes
0answers
21 views

Cannot delete from MariaDB federated table

In our web application, there are some federated tables which point to a remote server, it is used so that when writing log entries to the federated table they get actually stored on this remote ...
0
votes
1answer
42 views

Grant usage to a schema from another database

In PostgreSQL, how can I GRANT USAGE to a certain schema for a certain user in a certain database while I am in another database? I am connected to a database (let's say database first) as a user ...
0
votes
1answer
15 views

Creator of a MySQL table automatically granted all table permissions?

I recently read it in SilberSchatz book that in MySQL the creator of a relation/view is the owner and granted all permissions on the relation/element including the power to transfer these grants to ...
6
votes
0answers
186 views

Select permission denied when using linked server in a function unless inlining is off

We are encountering an unusual error in our beta environment after upgrading to SQL Server 2019. This occurs when selecting from a scalar-valued function. This error does not occur in our production ...
0
votes
1answer
99 views

SQL Server Management Studio Error Access Denied Editing Job Step

I recently changed the owner of a job from my user to sa. After the ownership change I am able to edit the Schedules and Notifications for the job. However all attempts to to create New, Insert, Edit, ...
0
votes
1answer
108 views

MariaDB does not start after restoring incremental backups with mariabackup

OS: CentOS 7 MariaDB: mariadb Ver 15.1 Distrib 10.4.12-MariaDB, for Linux (x86_64) using readline 5.1 I am creating a full backup every 7 days on a replication slave, and an incremental backup ...
0
votes
0answers
41 views

mysql 8 ndbcluster distributed privileges

I've setup a mysql 8 ndbcluster but cannot get the distributed privileges working. following how to setup distributed privileges using NDB_STORED_USER (https://dev.mysql.com/doc/refman/8.0/en/mysql-...
0
votes
0answers
21 views

Grant READ ONLY permissions to all tables in all databases [duplicate]

I created new role named "support" in my PostgreSQL. Now I need grant "READ ONLY" permissions for this role an ALL exists databases/tables. Also I need automatically granted same permissions on each ...
0
votes
1answer
106 views

SQL Server - Add signature to stored procedure by certificate does not work

I have a stored procedure in Database 1 that updates couple of tables in Database 1 and Database 2 To avoid granting calling login/user permissions to do table updates, I try to use code signing ...
0
votes
1answer
34 views

Database level access in Azure SQL managed instance

In my Azure SQL managed instance I have two databases, Database_A and Database_B. User A_ABC has access only to Database_A and he is part of role db_owner. When the tries to alter a table we are ...
1
vote
1answer
98 views

Changing the login name for user dbo

I have a database where the owner is Login1 but the username dbo is assigned to Login - login2. I understand in order to change the login name for the username dbo to sa I will have to use the below ...
0
votes
0answers
17 views

Does SSRS report user needs database level permission?

I have a separate reporting server and a separate database server. Now on the Reporting server site settings I could see there are some roles and users. Suppose a User BOB has ‘POWER USER’ role ...
9
votes
1answer
301 views

MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can't Bring It Online

I can take databases offline (via GUI) but can't bring them back online. The server details are as follow: RDBMS: MS SQL 2016 Express Host: Amazon AWS/RDS Free Tier Details/History of the Problem A ...
2
votes
2answers
78 views

Permission denied when trying to install sp_blitz on in the master database in Amazon RDS

I am trying to install sp_blitz on AWS RDS SQL Server (14.0.3223.3) standard edition and getting following error: Msg 262, Level 14, State 18, Procedure sp_Blitz, Line 1 [Batch Start Line 0] CREATE ...
5
votes
3answers
486 views

What grants should I give a user if I want the user to see all tables and views (view definitions) in every database in the server

I want a user to see all the tables and views in the each database on the server. I also want them to see the view definitions. By that I want to also be able to see how the views are created. That is,...
0
votes
0answers
37 views

Create multiple logins with the same permissions

I have a server instance with 100 databases in it. I need to create 20 new logins with access to 65 of the 100 databases. They all need to have the exact same permissions. The 20 logins should not ...
4
votes
0answers
65 views

how to remove all permissions in a database?

every time I need to either restore a database or reinitialize a replication publication I first (on the restored to be or subscription database) I script all the permissions, triggers, indexes, ...
1
vote
1answer
247 views

how to list the SSRS permissions in each folder in the reporting services server?

I have the following powershell script that downloads all the RDL from a reporting services server. I am not the author to whom I am very thankful. It has been very useful for downloading the RDLs. ...
0
votes
1answer
19 views

AWS RDS : Setting Create and other grants only for single Database is not working

We are using AWS RDS Mysql, and we are trying to give SELECT access to all databases i.e RO only, but for a single database, we want to give all permissions i.e CRUD. It's not working out ...
2
votes
5answers
266 views

Granting a user a permission to restore a database

In a database I created a user with the following roles: Server Roles public Database roles db_backupoperator db_ddladmin db_datareader db_datawriter The problem is I don't want to change the ...
0
votes
1answer
28 views

Manage Postgres user permissions with many databases and users

How do you manage users' permissions efficiently when your company has a lot of databases and users? My company has > 20 reporting databases. Whenever I need to change permission for some users, I ...
0
votes
1answer
22 views

How To Grant A User In AD Groups Which Is Denied To DML Commads, To Update On A Spesific Tables

I have a Active Directory user account named SQLQRY in my sql server. SQLQRY is permitted only read data. Those users can use onyl select statement. I need to give just update and delete permission on ...
0
votes
1answer
45 views

SQL Statement Layer Filter Queries Limit Access

Goal: Want to create a so called "SQL Statement Layer" which checks/filters all incoming queries. If incoming query is invalid, should be denied. Use-case: Limit database access and avoid ...
0
votes
1answer
59 views

List users permissions to tables and schemas on MSSQL 2016

List all permissions for a given role? has a nice query for listing users and their roles on a DB. How could we list all tables and users with their permissions on these tables?
0
votes
4answers
100 views

What role is able to grant role permissions on MSSQL 2016?

Unfortunately, we'll have to remove db_owner role from not admin users, because people were abusing it. We'll split roles permissions in 3 groups: 1) readonly (SELECT) with specific write (INSERT,...
0
votes
3answers
71 views

Grant MonitorAdmin / PROCESS privilege to user

I need to assign the monitoradmin privilege to a user because this is what an application called "dynatrace" needs to monitor the server (some details in a post on their site). According to https://...
3
votes
1answer
334 views

How to grant permission to execute stored procedure in master database from another database

Our developers have a domain account used by their application that needs to be able to execute stored procedures created in the master database using the "sp_" naming convention from other databases ...
0
votes
1answer
44 views

Query for: view users and permissions (roles) from root security folder (MS SQL)

On the Internet I found a lot of scripts how to display users and their permissions under a particular database (Security folder under table) - for example sp_helpuser. Currently, however, I need to ...
2
votes
2answers
54 views

Permission hierarchy vs. WITH GRANT OPTION

I have an Azure SQL database with this security setup: SchemaUpdater user with db_ddladmin, db_datawriter, and db_datareader roles. The user is used to execute database change scripts during ...
0
votes
0answers
67 views

How to handle spoon err: Permission Denied in Redis

I'm new to Redis and I'm facing this error on Windows 10 Pro (64 bit) when trying to do the background save of Redis: [14932] 18 Jan 10:57:24 # Failed saving the DB: Permission denied [14932] 18 Jan ...
0
votes
1answer
63 views

How to Grant A User Under A Sql Domain Account To Insert and Update Records

I have a sql domain account in sql server like DOMAIN\GroupName. There are many user accounts under that account like DOMAIN\user.name. I want to give insert and update permission only to a user under ...
0
votes
1answer
334 views

You do not have permission [closed]

I have this grant permission below use eNtsaRegistrationDB go grant select on UserReg to Users; Cannot find the object 'UserReg', because it does not exist or you do not have permission. Both of ...
2
votes
1answer
92 views

db_datawriter vs grant delete, update, insert

I have an application set up in which the service account uses a user defined role which has each object in the database defined with specific permissions. It seems that every table in the database is ...
0
votes
0answers
28 views

SSRS 2017 permissions required to deploy

I'm having issues with one of our developers deploying reports to SSRS, they seem to be able to deploy datasets, however not reports themselves. As a temporary measure, we've granted all privileges e....
0
votes
1answer
67 views

Create limited admin role in SQL Server that cannot alter row level security

I would like to know if there is a practical way to create an admin role in SQL Server that can essentially do anything except alter row level security policy. It is simple enough to create row level ...
3
votes
1answer
292 views

In the context of another principal what permissions hinge on the identity of the database owner?

By "database owner", here, I mean the principal whose SID is sys.databases.owner_sid. This answer to the question of best practices for database ownership includes the following: The answer here ...
13
votes
2answers
2k views

Why is database ownership by groups not allowed? Which user should own a database?

Per microsoft "ALTER AUTHORIZATION for databases for SQL Server": Requirements for the new owner: The new owner principal must be one of the following: A SQL Server authentication ...
-1
votes
2answers
75 views

Sql Server roles [closed]

Recently I was asked question - what is the difference between Standard Server roles and Fixed server roles. I know Fixed Server roles include: Sysadmin, Securityadmin, etc. I am not sure about ...
1
vote
1answer
45 views

postgresql: make objects owned by parent role

I have a set of apps that produce data. Each app has its own credentials to access the DB, and they all inherit from a common role (producer). I'd like to set default privileges to grant access to ...
8
votes
1answer
172 views

Permissions required for row counts to show up on Object Explorer Details

I'm having a weird security issue. I have a user that's using SSMS 18.2 on a SQL 2016 server. They are a member of db_datareader but when they pull up the the Row Count column in Object Explorer ...

1
2
3 4 5
27