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)

1
vote
1answer
58 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
670 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
261 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. ...
6
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
78 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 ...
0
votes
1answer
63 views

Prevent replication of ALTER commands

I am using MariaDB 10.0 multi-source replication for a specific use case. For security reasons, I would like to prevent ALTER commands on master to replicate (such as CREATE, ALTER, DROP...) whatever ...
-4
votes
1answer
475 views

How do I create multiple users with one login to have access to single database [closed]

What is the benefit of creating a login for users? If a login grants the principal entry into the server, I want to grant this login to three users: db-writer db-reader ddl-admin each with ...
2
votes
1answer
204 views

SQL Agent doesn't have perms to run a PowerShell script

I recently upgraded SQL Server from Windows 2008 R2 & SQL Server 2008 R2 to Windows 2012 R2 & SQL Server 2014 SP1. One of the sql agent jobs fails to run. The job runs a PowerShell script to ...
1
vote
2answers
293 views

Connecting to a new RDS instance from an EC2 instance

I'm trying to use MediaWiki and WP to connect to two MySQL databases. The databases are working properly and so are the forms but when I try to establish a connection to the database with MediaWiki ...
3
votes
1answer
168 views

Prevent explicit insert into serial columns

I want to prevent explicit inserts into serial columns. I have come up to the following trigger: drop table test_table; create table test_table( id bigserial primary key, foobar text ); create or ...
0
votes
1answer
235 views

how do you revoke create table from a user on postgresql 9.4?

I'm trying to create a postgresql user that can select but can't create or drop, insert and so on on a database but I cannot for the life of me figure out how to prevent a user from creating its own ...
1
vote
1answer
21 views

Grant Permissions Within Report SP

Leaving aside why one would want to do such a thing: In MS SQL Server 2008, Is it possible to have a report SP grant permissions to a column used in that report to a table in a database other than ...
1
vote
1answer
118 views

Permissions for sys.database_mirroring in SQL Server

I need to assign permission to use sys.database_mirroring and of course I want to give the minimum amount of privilege. When I looked at microsofts homepage it says: To see the row for a database ...
0
votes
1answer
39 views

How to grant a user the rights to access to all new (future) databases? [duplicate]

On my development machine, I often create new web instances that all run as NT AUTHORITY\NETWORK SERVICE. I want to grant this account rights to access all new databases that I create in the future in ...
8
votes
3answers
3k views

Property Size is not available for database

I recently restored a database to the same instance it was backed up from (SQL Server 2008 R2 Enterprise) and found that I couldn't access the database properties. I have done the following: ...
0
votes
1answer
409 views

What privileges are needed to run EXPLAIN PLAN FOR CREATE INDEX?

My user can EXPLAIN PLAN FOR any query I like, but not for CREATE INDEX. I need to do that in order to estimate a suggested index's size, and using sysdba is out of question. What privileges should I ...
2
votes
3answers
191 views

script to show all the permissions for a table

inside my database I have a procedure called spGen2_tblIE_SchedProcess_Update. when I run this script select * from sys.objects where name = 'spGen2_tblIE_SchedProcess_Update' Inside the same ...
1
vote
1answer
17 views

Grant privileges in other table than mysql table

I have been requested to create a back-end area for an existing website (on a provider's server), consisting of several tables and php pages. This back-end area should not be accessible/visible to ...
2
votes
1answer
564 views

Can't alter default privileges

I followed the steps below. I installed PostgreSQL. I logged in as postgres via (sudo -i -u postgres) I created new user new_user via shell script createuser --interactive I granted that user ...
-2
votes
1answer
52 views

Allowing non-sysadmin users to see SQL Server execution plans

Is this possible ? On SQL Server 2012+, grant access to a non sysadmin user to see the execution plans ? And can this be done for selected databases only ?
4
votes
1answer
439 views

Cannot revoke default privileges from postgresql user

I am using the psql tool: Command: my_db=# \ddp Result: Default access privileges Owner | Schema | Type | Access privileges ----------------+-------...
4
votes
2answers
215 views

postgres: how can I allow index creation but no table mutations or table drops by the same user?

I am setting up a postgres server with what is going to be a (mostly) read-only workload. I would like to allow myself and colleagues to create/drop indices as we see fit, without allowing ...
0
votes
0answers
17 views

Redshift schema access permissions not applied to new tables [duplicate]

I've granted privileges to a group in Redshift: GRANT USAGE ON SCHEMA public TO GROUP read_clients; GRANT SELECT ON ALL TABLES IN SCHEMA public TO GROUP read_clients; However when I create a new ...
2
votes
1answer
34 views

Insufficient Prilivege for Function

I'm using a Function that I can't read, when I try to open it, I can't see the definition. I get following error Error : Insufficient privilege. Nevertheless, it is being executed by my app ...
1
vote
1answer
255 views

SSIS Run Excel Macro Error

I have an SSIS package that populates an Excel file. The package is run from a SQL Server Agent job. It all runs fine, but now I have added a Macro to the Excel file. This macro causes the Package to ...
0
votes
2answers
40 views

PostgreSQL user only drop some tables

Is there a way to have a PostgreSQL user that can drop all but specified tables? We need the user to be able to drop some tables but not all. It would be preferred to be able to use something like ...
0
votes
1answer
118 views

List of role permissions including other roles - how can I find out the roles that belong to other roles?

I can see the permissions of a role in a database using the scripts in List all permissions for a given role? However, It does not show me when the role belongs to a another role. For ...
-1
votes
1answer
419 views

How to give a user “create any database” permission in SQL Server? [closed]

Is it different from the dbcreator permission? Can anybody explain the process?
3
votes
3answers
69 views

Finding out what permissions are required by the SQL Server Agent Jobs

I've been looking at this for a while and I can't work out an easy way to do this. As it stands every job in the database runs under SA level rights (horrifying thought) I'm sure some of the jobs ...
0
votes
3answers
126 views

How to preseve Execute permissions for MySQL procedure with alter procedure (Drop/Create)

In MySQL you can not alter procedure rather you have to perform drop/create procedure to alter the body of the procedure. The problem is doing drop/create also removes the execute permissions given on ...
4
votes
1answer
4k views

SQL Server data folder access rights

I did a fresh SQL Server 2014 install. Next, I wanted to attach some databases from a previous SQL Server 2012 server. I copied all mdf and ldf files to the data directory, but when I tried to attach ...
3
votes
3answers
474 views

“Specify SQL Server administrators” - unusual default value

When installing SQL Server, you get to specify SQL Server administrators, i.e., the list of users initially in the sysadmin role. By default, this list contains the current user. (Image quoted from ...
2
votes
1answer
193 views

No mysql database in mysql server - how do I give users permissions?

I have a mysql server (5.5.44) running on my local Ubuntu 14 machine. I can start the interactive shell via $ mysql When I ask to see all the databases, there is only one mysql> SHOW DATABASES; ...
2
votes
1answer
43 views

Permissions to be granted to developers to investigate jobs, queries, and packages

I have just installed a new sql server 2014 server, migrated some databases there and connected some applications to them. These servers have also SSAS and SSIS. I have a group of developers there ...
2
votes
1answer
59 views

How to find out ALL the users that can connect to SSAS?

I have an user called mycompany\aives that is not listed in the list of administrators in the SSAS, not belong to any of the AD (active directory) groups listed there, however, he can connect to ...
6
votes
3answers
65 views

Can't get access to other database

I am working on a project for my university. They gave me a login username and password for MySQL database they've setup on the server. With that username and password, I'm able to login to the ...
0
votes
1answer
53 views

Oracle 11g XE - Using a stored procedure to grant privileges to a table

I need to write a stored procedure that will grant certain privileges over a table to a user. However it appears that GRANT cannot be used within a Stored Procedure. My Curent code is as follows: ...
9
votes
1answer
62 views

When are privileges listed in \l and when not?

When are access privileges listed by \l, and when are they not? The access privileges listed by \l can change after a grant and revoke: $ createuser -EP my_readonly $ psql development development=# \...
1
vote
1answer
44 views

What are the default fixed server role members for SQL Server 2012

What are the default fixed server role members for newly created SQL Server 2012 instance using all default options. As given by EXEC sp_helpsrvrolemember
1
vote
1answer
50 views

Temporary permissions for DDL

I was hoping to use user impersonation to setup a user that has permissions to modify DDL, and only when I need to deploy DDL changes would I impersonate that user. This way I can use my windows ...
1
vote
1answer
54 views

Apply the select privilege to all users in mysql

I have 30 plus MySQL users their permissions vary from one another. I want to GRANT SELECT privilege to all of the 30 users. Is there any one command that I can use that can grant select to all 30 ...
2
votes
1answer
358 views

Granting access to the Job Activity Monitor

I'm trying to grant access to the Job Activity Monitor. On my model office server I can create a new login and add it to the SQLAgentReaderRole role in msdb, and the id has access to the monitor. ...
0
votes
1answer
1k views

GRANT EXECUTE ON PROCEDURE unable to USE database

I am attempting to grant a user execute privileges to a single stored procedure without any other privileges in a MySQL 5.1.45 instance. The stored procedure is defined with SQL SECURITY as DEFINER. ...
0
votes
1answer
90 views

What are the user privileges required to for an ssrs report owner to 'send email'

Yes, this question is a duplicate to: SSRS - rsAccessDenied error but that question is 2 years old and unanswered...so I thought I might try again. Our DBA has recently departed leaving behind a ...
1
vote
1answer
28 views

Methods of Denying login by specific SQL Authenticated user using Management Studio

I am trying to create a way of restricting/complicating access, for a particular user, to login to SQL Server, using Management Studio with SQL Server Authentication. I would like a way that also ...
0
votes
1answer
546 views

Steps to determine why NT AUTHORITY\SYSTEM has permission on one database, but not another

Have a service running under NT AUTHORITY\SYSTEM (Local System) and accessing local SQL Server database using Windows auth. On one database they have permission to read/write - on other database (on ...
3
votes
2answers
2k views

List all databases of a certain user ( SQL Server 2008 R2 )

I'm really looking for this answer for some time. I bet there is a post here but, I really can't find ( even on google ). I think it's a simple task. I want to list all databases for a specific user....
1
vote
1answer
49 views

Real-world scenarios for table with DENY SELECT and GRANT [INSERT/UPDATE/DELETE] [closed]

What is real-world scenarios for this type of permissions? May be it is generally not valid, and made by mistake? Should this kind of permissions be avoided (or prohibited)?
3
votes
1answer
139 views

Reg: Default Privileges on PostgreSQL Schemas

I have a situation where many users can create database objects across all the available schema. There is a generic user pg_dump_user used for by all the developers to dump the whole database to ...