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
16 views

Grant permissions to only specific tables in a Schema

I am having a schema where I wanted to grant permissions in the following manner. What is the right way of doing this? To keep this simple, I am putting an example. SCHEMA - HR TABLES: GEO_EMPLOYEE ...
0
votes
0answers
6 views

In Redshift how can I create an user which which has only user creation privileges?

The primary requirement is to automatically create or alter users based on user information stored in a table. I am planning to write a stored procedure / use Databricks notebook to do the automation. ...
0
votes
0answers
12 views

Mysql user with grant option cannot grant access to another user

in my mysql server there is a user mgenkin with the following privileges: +---------------------------------------------------------------------------+ | Grants for mgenkin@% ...
0
votes
0answers
9 views

db_datawriter and db_ddladmin on a server-level? [duplicate]

Ok, since SQL Server 2016 we have new server-level permissions that allow to grant connect and select to/on any exising or future databases on the server instance use master grant connect any ...
0
votes
0answers
11 views

SQL Group Execution Rights to Read only SPs and functions - By not changing objects' schemas

We have a SQL Developer Group.. We want to give them access to execute functions and sps but not to any that amends data in any way.. We currently only have the DBO schema and all objects sits on that ...
0
votes
1answer
38 views

Oracle: ORA-00942: “table or view does not exist” in SQL Developer

in SQL Developer when i get session information he return me this error message: (ORA-00942: "table or view does not exist"). Can i resolve this with add grant to privilege of my user? Wich ...
0
votes
1answer
17 views

Is it possible to grant a user the equivalence of ownership over a another users schema?

Im trying to create a trainer/trainee environment in Oracle 18c XE. So far I have 4 trainee users which all have the hr-sample installed. Now, I plan on having one trainer user that is able see ...
0
votes
1answer
15 views

“Permission denied” in Postgres 12 trying to use to_regclass() on table partitions

I have a partitioned table public.events owned by user web. Running this query: SELECT to_regclass('public.events_52642b42e4b0889a77dcd6db') (to confirm that a partition is present for a given ...
0
votes
1answer
67 views

Execute privilege granted successfully, but I can't execute the procedure

I am using the database as me. The procedure exists as an object that belongs to me. Grant sucessful. But when I attempt to EXECUTE insert_into_purified; i get Error starting at line : 469 in ...
-1
votes
1answer
18 views

Permissions needed to list databases

A remote application is able to list database names if we give 'sa' rights to the application group. If we remove 'sa' rights, just with public server role they can't see databases, even the ...
0
votes
1answer
22 views

postgresql grant user privilages to dynamically created tables

We have 2 postgresql users. One user (dbworkeruser) for creating tables dynamically (from C# worker) and other user (injestworkeruser) for inserting data into these tables (from another C# worker as ...
0
votes
1answer
24 views

MS SQL Server 2016 - Database Security - Login Permissions

I have an SQL Server 2016 database with Always On structure. I have a login that I called x. My x login's properties are: Default database: abc Server roles: public (ticked) User mapping: Map (ticked)...
0
votes
0answers
19 views

Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE' vulnerability for Windows 2008 R2 SQL

I have a MSSQL Windows 2008 R2 server. Vulnerability for "Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE'" has been found. Current ...
0
votes
1answer
11 views

POWA analyzer displays error 500 after logging in

I tried to install POWA web analyzer. I can see the login page but after login there is a 500 error message. This is the error at the server: ProgrammingError: (psycopg2.errors.InsufficientPrivilege) ...
1
vote
1answer
31 views

Do I need GRANT for INSERT to table If has EXECUTION GRANT for procedure?

I have five domain users and five roles in my database. GRANT EXECUTE adds to the appropriate roles. Roles are included in other roles, i.e. at most we have one role that has grants for two procedures,...
0
votes
2answers
38 views

Oracle 12c - Insufficient Privileges When Trying To Create A Trigger With SYS User

I want to create a trigger for CRE schema. I'm trying to create this trigger with SYS user but I have insufficient privileges error. My trigger: CREATE OR REPLACE TRIGGER CRE.TRIGGER_NAME AFTER LOGON ...
0
votes
1answer
21 views

How to check who has permission to execute a stored procedure?

I have two environments/servers. Each has two databases, say DATABASE_A and DATABASE_B. There is a stored procedure in DATABASE_A (in both environments) that queries DATABASE_B and also calls multiple ...
0
votes
1answer
20 views

Oracle auditing: Is it possible to log when a permission is being used?

Does Oracle offer a way to log instances where a given permission is evaluated? Suppose I GRANT SELECT ANY DICTIONARY or something similar to a role, I am looking for a way to log every instance where ...
0
votes
0answers
17 views

Unable to grant privileges with admin account

I'm running MariaDB version 10.4.8 on Amazon RDS. Once the server is up and running, I need to create some databases, users and grant privileges to those users. Creating the databases and users works ...
1
vote
2answers
63 views

How to remove dbcreator server role?

I was able to add the dbcreator server role to a user of a SQL Server DB, thanks to this nice question/answer: create-database-permission How can I REMOVE that permission? Is there a stored procedure ...
0
votes
0answers
15 views

Revoke privileges on an object a role doesn't own in Postgres

Context I created a fresh Azure Database for Postgres and here is how it looks like at first: postgres> \l +-------------------+-----------------+------------+----------------------------+----------...
0
votes
1answer
42 views

Postgres role does not inherit permissions from its member role

I want to group my postgres database permissions to set of roles and then assign users to these parent roles to manage all permissions from a central place. I created a role called admins and granted ...
2
votes
1answer
62 views

Copy csv file into different schema [closed]

I need to import data from a csv file which from database a schema a into another database b schema b. I used the pgAdmin running the export and when I import the data using the same tool pgAdmin and/...
0
votes
1answer
32 views

Show all privileges given to a schema or user in postgres

I want to know what are the privileges a given schema or user has in Postgres. Like whether it can create a table, view, function, sequences or not. I found one query but it showed privileges on table ...
0
votes
1answer
20 views

Revoke access to selected system tables

In Vertica, the SELECT privilege on all system tables in V_CATALOG and V_MONITOR is granted to PUBLIC. Therefore, by default all users can query them. And not all system tables seem appropriate to be ...
0
votes
1answer
16 views

Automatically give grants to particular users PostgreSQL

Every time when someone creates a table I have to give grants on select, insert, and so on to particular users. Are there any solutions to make it automatically? Thanks!
1
vote
1answer
30 views

What can I do with VIEW DEFINITION permissions that I can't do with ALTER permissions?

I have created a new user which has ALTER permissions on my database: CREATE LOGIN [testuser] WITH PASSWORD = '...'; CREATE USER [testuser] FOR LOGIN [testuser]; GRANT ALTER TO [testuser]; To my ...
1
vote
2answers
40 views

Column name on NOT NULL constaint violation not shown

I'm using an Oracle 19 DB that is structured into multiple layers by using DB users. Here is a simplified overview of the structure: User DATA: Has the table XTEST and the view TEST. The view is ...
0
votes
1answer
64 views

SQL Server 2016 - Availability Groups - How To Copy Permissions To Secondary Node [duplicate]

SQL Server 2016 SSMS v18.4 I want to create the same logins and give the same privileges on both node. In primary node I have no problem about this operation. But when I create the same login on ...
0
votes
1answer
17 views

Permission denied while trying to delete even when delete is granted

I recently had this issue where I created a database user and gave delete and update permission. Yet, I was getting permission denied on a delete query. Create user: create user username password '...
0
votes
2answers
348 views

how to resolve ORA-04042: procedure, function, package, or package body does not exist and ORA-00942: table or view does not exist

I am trying to grant EXECUTE and READ privilege on two tables to a user ktest1. grant EXECUTE on SYS.KIR_DOKUMENT to ktest2; grant READ on SYS.KIR_DOKUMENT to ktest2; when i give grant execute i get ...
-1
votes
1answer
31 views

how to resolve the error “ADMIN option not granted for role 'my_role_1'” [closed]

I am trying to grant a role to user. grant my_role_1 to ktest1 with admin option; But i am getting the below error Error report - ORA-01932: ADMIN option not granted for role 'my_role_1' 01932. 00000 ...
0
votes
0answers
33 views

SSRS 2017 Subscription - Permissions granted to user '' are insufficient for performing this operation

I've seen lots of issues relating to 'permissions....insufficient for performing this operation' which can arise in a variety of places when related to SSRS - deploying reports, running reports etc.......
1
vote
1answer
44 views

Bulk Insert Permissions Issues

I'm experiencing the dreaded Msg 4861 error message when attempting to use Bulk Insert on a 2012 SP4 SQL Server. "Cannot bulk load because the file "\PathToFileShare.d1.xxx.com\folder\file.dat" could ...
0
votes
2answers
51 views

How to create an user with permission to do everything but drop databases? [duplicate]

If it is easier, the user can be denied only deletion of one specific database instead of any database.
0
votes
1answer
45 views

SQL server Service Accounts permission

I will be changing the existing SQL Server Service accounts from the default to Domain accounts from the SSCM which i believe will set all the required permission. One thing I am not sure whether the ...
0
votes
1answer
134 views

Cannot drop the user because it does not exist or you do not have permission

I am getting this message for some users when executing sp_revokedbaccess procedure for database users. Users I am trying to remove are selected from sys.database_principals with type = S, W or G (sql ...
0
votes
0answers
11 views

Non-Super user permissions required to allow a user to create a schema within a database that is owned newly created user

I'm able to run the following as postgres or any other user which has SUPERUSER ("dba1" has SUPERUSER in this case) psql -U dba1 dev << SQL create user udev1; create schema udev1 authorization ...
0
votes
1answer
38 views

What permissions are required for complex cross-schema materialized view in Oracle?

I have a complex cross-schema query that I'd like to create as a materialized view in Oracle 19c (although the database has been ported forward from numerous historical versions of Oracle). This ...
0
votes
1answer
39 views

Permission to select sys tables in stored procedure

I have implemented the stored procedure to check if a specific [schema].[procedure] exists. CREATE PROCEDURE [BlobCheckExisting].[usp_DoesStoredProcedureExist] @schemaName varchar(128), @...
0
votes
1answer
23 views

Analyst MSDB Access SQL Server 2017

i'm an accidental DBA for a company and having trouble figuring out this permissions situation. We have a new 2017 SQL server that I would like to get our report writer / analysts access to a few of ...
0
votes
1answer
26 views

Alter default privileges in postgres for other roles

Let's say I have a role called user1, user2 and postgres. Is it possible to alter the default privileges while logged in as postgres for objects created by user1 so that user2 can see them? This is ...
0
votes
0answers
31 views

Granting privileges on databases using wildcards

I'm using SQL Server and there are multiple databases on the instance. I'm wondering if there is any possibility to set up access rights with wildcards. I would like a team to be able to create/drop/...
1
vote
2answers
73 views

How to grant permissions to allow anything inside a SQL Server schema?

I have a schema called training. I have a new role called training_modify. Here are the desired permissions for users placed in that role: Select, update, insert, and delete permissions on any object ...
1
vote
1answer
58 views

SQL Server Grant CRUD to Users on One Schema

I have a schema called training. I want users who will be trained to have CRUD permissions on any object on that schema. I do not want them to have any other permissions on any other object outside ...
2
votes
1answer
65 views

Microsoft SQL Server - Permission to create a Snapshot

I've developed a set of SSIS packages to load a data warehouse. In order to manage any issue that may arise during package execution, each package starts by creating a snapshot of the data warehouse. ...
10
votes
2answers
591 views

Break the link between a Database User and SQL Server Login

When restoring database from once instance to another one sometimes has to relink SQL Server Logins to the Database User. This is normally achieved with one of the following procedures. Deprecated ...
0
votes
2answers
48 views

Deny certain user from updating certain rows [duplicate]

Say I have a table like this: canModify | name | age ------------------------ 1 | John | 24 0 | Nick | 21 I want to grant update access to a specific user only where canModify=1 I ...
0
votes
0answers
82 views

Permission denied to create new tablespace for PostgreSQL data

I can't set my PostgreSQL data folder to a drive other than the C drive (Windows 8 machine). 1) If I try to do so when installing PostgreSQL, the installation fails. Therefore I need to choose the C ...
1
vote
1answer
47 views

Postgres role does not inherit permissions of superuser role via membership in that role

In the snippet below, the role writer is a member of a superuser role named admin. The admin role can insert rows into a table but the writer role cannot insert rows into the same table. Why does the ...

1
2 3 4 5
28