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

learn more… | top users | synonyms (2)

4
votes
2answers
176 views

SQL Server - granting permissions to an entire schema vs. object?

I'm very green when it comes to the world of database permissions management in SQL Sever. Let's keep an example simple. Say account 'admin' is the owner of schemas A, B, and C. There another ...
1
vote
1answer
92 views

postgres user cannot access location of new data directory

I moved my postgresql 9.3 data directory to a different drive, however, my postgres user cannot seem to access that new drive despite my best efforts. I am running on ubuntu 14.04 LTS x64. So I ...
5
votes
1answer
52 views

Checking SQL AlwaysOn backup target with fn_hadr_backup_is_preferred_replica, different answers with different permissions

I've implemented AlwaysON backup with Ola's script, those are running fine on designated server configured for backup. I would like to automatically check backups using sql-scripts fired from a ...
3
votes
1answer
140 views

SQL Server - SQL Agent - Allow a Group to own a job

Scenario There are three separate groups of users in our organisations (development, support, implementation). As it stands everyone is using a single login for everything. We are starting to move ...
0
votes
0answers
61 views

Modify MySQL information_schema (specially create_time) on AWS RDS?

I am trying to modify the create_time of an entire database, tables, etc. I have found that information_schema tables stores the creation date of the tables on the column CREATE_TIME. Unfortunately ...
4
votes
2answers
278 views

db_datareader, db_datawriter and db_owner permissions [duplicate]

First of all, sry because I am not a DBA and I'm not familiar with all the permissions. My question is, if I give a user db_owner permissions on one database. Do I need to give also db_datareader and ...
5
votes
1answer
56 views

Recover SA Password - PSTools - Not working

I'm on a new company, and the first thing I saw is that they don't even know how many instances they have. they don't have passwords and the old DBA had no Idea what he was doing. long story short, I ...
0
votes
1answer
2k views

error “--secure-file-priv option” when save selection to csv

I try to save a very large select (more than 70 milion rows into csv file) on Win 2012 R2 server I execute query as root , but I think there is still some problem with privileges select * INTO ...
1
vote
3answers
100 views

How to create a non-sa SQL Server login / access without control server permission

I have SQL Server, and I need to give access to other users to run basic queries (just select on 1 database). I have created a login for a user, and have amended their permissions, but once I deny ...
0
votes
2answers
148 views

What is the alternate to SA account in SQL Server? [closed]

My client is currently using SQL Server for their app. At this time they are using SA account everywhere. For security reasons we need to disable the SA account. The solution I've is create another ...
4
votes
1answer
387 views

Getting a proxy account to backup to a share using Ola Hallengrens backup script

I have a SQL Server 2012 Standard install where the Engine and Agent are running under the default NT Service accounts Engine - NT Service\MSSQLSERVER Agent - NT Service\SQLSERVERAGENT I am trying ...
1
vote
0answers
44 views

SQL Server 2014 proxy error

I'm rather confused by this one and can't see any options in previous posts about similar things. I've created a credential -> proxy account, that will run a PowerShell script. When I run the ...
2
votes
2answers
342 views

SQL Server logins and users — assign multiple logins to a single user? [duplicate]

In SSMS, since I can't assign multiple login objects to a single user object, what is a best practice to achieve an equivalent security model? For example, I have 20 logins and want to give them all ...
1
vote
1answer
129 views

Grant access to all objects (with a few exceptions) to a role

In SQL Server 2014, I want to create a role that will have access (select, delete, update, insert, execute) to all the tables, views, stored procedures, except a certain list of tables that contain ...
4
votes
1answer
96 views

sa doesn't have permissions to other database through synonyms with the Service Broker

I've been trying to get this Service Broker and timers thing to work for over a week straight now, so bear with me if this comes off as.. uh.. ragey. I'm also fairly inexperienced when it comes to SQL ...
0
votes
1answer
86 views

Cannot fix ERROR:ORA-01031: insufficient privileges

I have tried almost every solution on the internet however I still cannot fix this problem. I cannot login as sysdba every time I try SQL>connect /as sysdba I get the error ERROR:ORA-01031: ...
1
vote
1answer
40 views

Adding new user in Postgres

I am using AWS RDS PostgreSQL and currently up and running. I would like to know how I can add a new user but only grant SELECT on an existing DB. The way I connect to my RDS from my PC is by using a ...
1
vote
1answer
58 views

Stored Procedures execution permissions

So what I am trying to do is to limit the access to a stored procedure so that only another stored procedure may call it. Here is an example: create procedure Database_Deployment_Proc -- This ...
0
votes
1answer
74 views

User cannot create schema in PostgresSQL database

I'm trying to setup a "deployment" user which can create and alter tables on an existing database in addition to selecting, updating, inserting and deleting records. Here is what I've tried so far: -...
5
votes
1answer
267 views

Restrict Postgres roles by IP address outside of the pg_hba.conf file

I am currently adding Postgres support to a deployment tool that currently only supports MySQL. This tool dynamically provisions and configures a database, among other things. In MySQL, we can ...
1
vote
1answer
52 views

Forbid user to query internal SQL server information

I'm trying to forbid database user to get SQL server internal information. Script that creates DB user: CREATE USER [testuser] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo] DENY SELECT, INSERT, UPDATE, ...
0
votes
2answers
40 views

MySQL show all grants

I have over 100 system and admin users in my db server. Does anyone know how to show their grants by running a single query? Thank you very much.
1
vote
1answer
73 views

How do I GRANT for all tables across all schemas

I want to GRANT SELECT ON ALL TABLES TO foo; But postgres tells me I have a syntax error at "TO". It expects a GRANT like: GRANT SELECT ON ALL TABLES IN SCHEMA public TO foo; ...
2
votes
2answers
194 views

SQL Server REVOKE requires CASCADE

I have the following graph: B granted select on D and D granted select on E and E granted select on G. B has grant select with grant option and has granted select D with grant option. D has grant ...
4
votes
2answers
1k views

DDL_admin vs db_owner permissions

I'm taking over a project that involves removing and limiting permissions of all database users across our server farm. (fun times) One of the permissions currently being limited is db_owner ...
1
vote
2answers
64 views

DENY insert,update,delete to user (PostgreSQL)

I wonder if Postgres support the DENY command. I search in the documentation but I couldn't find anything about deny. I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but I don't want user1 to ...
0
votes
1answer
108 views

User databases inaccessible after physical restart

We have an unusual error happening on the SQL Server. After restarting the physical server where the SQL Server instance is installed, the user databases are not accessible. System databases are ...
1
vote
1answer
47 views

Active Directory group as a schema in SQL Server

In SQL Server 2008 R2 we have a database that is being maintained by a team of developers. Each of them should have permissions to perform DDL operations such as adding a column or creating a table. ...
1
vote
4answers
6k views

grant all privileges of all tables in database to a user

I use oracle 12c. I try to grant all privileges of all tables to a user. And in future I don't need to add any privileges to that user. I need to do this. I don't want to grant system tables to that ...
13
votes
1answer
1k views

Running SSIS package from SQL Agent job owned by a non-sysadmin domain user

I have two SSIS packages that run scheduled overnight (via SQL Server Agent) as part of a larger SSIS deployment, without any issues. Everything is using Windows authentication, and the scheduled job ...
0
votes
0answers
12 views

Storing default user type roles & module roles

I have multiple user types and each user type would need to be assigned different roles. However, I also build the application with Modules that can be selected by users when they subscribe. Each of ...
1
vote
0answers
21 views

Grant permission to update dbmail

We want to grant a user the ability to update their own mail connection profile used by db mail in msdb. For example, when the IT company maintaining the mail server wants to change the password. We ...
3
votes
2answers
132 views

Assigning permissions for sysmail_update_account_sp

I have a Microsoft SQL Server 2014. The mail system is configured via DBMail and there is one stored proc in main web app (having its own database) which executes msdb's sysmail_update_account_sp by ...
0
votes
1answer
178 views

How to deny drop, delete permission for a table?

I want to give Create , alter , read permission on object to user but not insert , update ,delete,drop permission to user , How can i do it in sql server 2008?
1
vote
2answers
175 views

Permissions needed for dbms_metadata.get_ddl in a function

Oracle Enterprise 11.2.0.3 I'm receiving: ORA-31603: object "string of type "string" not found in schema "string" when executing a function that calls dbms_metadata.get_ddl. I know that ...
0
votes
0answers
17 views

Basic 'grant proxy' failing

Using MariaDB 10, I'm trying a basic grant proxy... - and getting no success. I've tried many variations on the below session - can anyone hint at the problem? In the below, I'd expect the final ...
0
votes
2answers
69 views

grant access to user 'root' to all databases, but least specific one

I've got the users: root, lmanager. And too, a few databases: db1, db2, db3,... I want to grant all privileges to user 'root' over all databases, except for the db2. The user 'lmanager' will get all ...
2
votes
2answers
40 views

Transferring grants from one mysql DB to another

I would like to migrate a mysql DB from one server (Server A) to another (Server B). I took a Mysqldump and imported into the B. Now, I would also like to export all the grants from A to B, to do so ...
0
votes
1answer
32 views

Permissions granted are insufficient for this operation

I am using Report Builder 3.0 and have been trying to run reports using AdventureWorks 2014 in SQL Server Express 2014. My report Server is http://John-PC/ReportServer_SQLExpress. When I click Run in ...
1
vote
1answer
182 views

The process cannot access the file because it is being used by another process

I'm using SQL Server 2008 R2. Absolutely new to DBA role, but I've worked with SQL and VS for a while. I've installed the 2 aforementioned softwares on my home computer. If I have VS2010 open and ...
4
votes
1answer
65 views

How do I set permissions for Package Body

Here's my situation (slightly envaguened to protect the innocent): I have a package on a Test system and a package on Prod system that need to have identical permissions to access exiting packages and ...
1
vote
1answer
40 views

permissions for schema compare and view job history

I need to grant these permissions, what would be the minimum level I could grant so that they can do their job? I am looking at SQL Server Agent Fixed Database Roles and also Database Engine ...
0
votes
1answer
133 views

PostgreSQL error moving data directory to home folder

I have a problem with the moving of my data directory of PostgreSQL. I found many different ways, but none worked. The most sensible way for me was: Stop PostgreSQL Copy data from old folder to new ...
1
vote
2answers
321 views

how to sucessfully revoke view any definition (or any other server permissions)?

I had to grant a server permissions to an active directory group, in order to solve a LIVE Bug: GRANT VIEW ANY DEFINITION TO [mycompany\webDevSeniors] GO after the permission was no longer needed I ...
1
vote
1answer
57 views

grant dbmail access to account

We have a server with a number of (increasing) databases, each of the "databases" needs to be able to use dbmail. Each (database's) mail account is different and configured via a custom ui. We created ...
2
votes
1answer
650 views

Command fails as CmdExec job but succeeds from console

I have a SQL Server 2014 Agent Job (Type: "Operating system (CmdExec)", Run as: "SQL Server Agent Service Account", Owner: sa) that executes the following command: powershell -ExecutionPolicy Bypass -...
3
votes
1answer
255 views

Do not have permission to use 'dbo' when creating a view

I want to create a user with minimal required access to two databases within a server. The user will be used by someone from a third party integrating a Business Intelligence tool into our database. ...
5
votes
1answer
2k views

How to manage DEFAULT PRIVILEGES for USERs on a DATABASE vs SCHEMA?

I want to migrate a fairly simple, internal, database driven application from SQLite3 to PostgreSQL 9.3 and tighten the permissions in the DB as I go. The application currently consists of a command ...
1
vote
1answer
77 views

Permission in schema for user

I created a default database and created some schemas within this database. Created users for each schema, now I want to give full permission for each user in your schema only, how should I do?
1
vote
1answer
96 views

DENY VIEW DEFINITION TO PUBLIC

I have a SQL account with no permissions other than having the public role. I have run the following command to deny permissions to the system views: use master DENY VIEW ANY DEFINITION TO ...