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)

0
votes
1answer
38 views

Grant Select on some columns for specific user

I have a windows group with 20 people and all 20 people in the group were revoked access for some columns in the table. Now I need to add the select permissions for 2 of the users in this windows ...
0
votes
1answer
117 views

How can I limit a user to only be able to run procs in a schema, which access another db?

In a SQL Server 2012 SP2 Standard Edition instance I have a user in database A that needs to be able to run stored procedures in schema foo within that database. They shouldn't be able to do anything ...
0
votes
1answer
147 views

Trying to add permission to a Role is failing

I am trying to add a role into Create and Restore permissions and After researching online, it sounds like it should be as easy as using the GRANT statement. So far so good. However, my simple grant ...
2
votes
1answer
158 views

SQL Server : GRANT REFERENCES Fails With Msg 15151 as Windows User with sysadmin role and also as 'sa' [closed]

Okay, what am I missing? Someone please hit me with the proverbial clue-by-four. On SQL Server 2008 R2, I execute this command: GRANT REFERENCES ON ASYMMETRIC KEY ::IRESKey to XYZZYEXT; I get this ...
2
votes
1answer
87 views

MySQL stored procedure user privilege

I have a query regarding user permission on a stored procedure. If a user that does not have permissions to create tables in a database, but it does have permissions to create and execute stored ...
1
vote
1answer
166 views

SQL User Permissions for Continuous Integration via DbUp and Octopus

Currently, our deverloper group has started using DbUp and Octopus to do Continuous Integration on SQL Database Deployments. We have created a Domain user which will utilized to do the SQL Database ...
0
votes
2answers
181 views

how to GRANT EXECUTE on MySQL

I updated the timezone on an AWS MySql instance, and tech support told me I also had to runt his command for each MySql user: GRANT EXECUTE ON PyupROCEDURE `mysql`.`store_time_zone` TO ...
1
vote
1answer
34 views

Permissions to Create DB's and be able to perform any function only on those DB's

I am looking for a way to allow users to create databases which only they and SA accounts will have access to (Perform any function; creating/deleteing tables, deleting the DB, etc). For example, ...
2
votes
2answers
1k views

How do I give root@localhost permission to grant privileges in MySQL?

Whenever I try to Grant Privileges as root@localhost, it says permission denied (using password=Yes). My root user is the one that I am logged in as. I verify this by select user(); It responds ...
8
votes
1answer
790 views

Why is a new user able to create tables in PostgreSQL?

I followed two tutorials to create a DB with: a fully privileged user link a read-only user link I then got a tip from CJ Estel's tutorial stating that "you may have inherited the ability to ...
0
votes
1answer
50 views

GRANT permission to access to respective creator

Does the following command: GRANT SELECT ON EVENT TO STUDENT; grant student access to whole EVENT table? If yes, how to only give STUDENT access to EVENT(s) record created by respective STUDENT?
0
votes
0answers
63 views

MySQL denying access to user with necessary privileges

I have a MySQL server and a user with access to all databases. When this user attempts to connect to the database and execute a query, access is denied. I have ran the following statement (specifics ...
4
votes
1answer
4k views

GRANT permissions to all tables, views, procedures in SQL Server 2000

I was wondering if there was a fairly efficient way to use T-SQL with SQL Server 2000 syntax to GRANT SELECT, INSERT, UPDATE, DELETE, on all TABLES and VIEWS for a particular database while excluding ...
4
votes
1answer
2k views

SQL Server 2014 Replication - The process could not connect to Subscriber 'xxx'

I have just set up very basic transactional replication on SQL Server 2014. The Publisher and Distributor are one and the same. I have configured the Publisher to push to the Subscriber, so any and ...
1
vote
0answers
144 views

Permissions for executing subscription in SSRS

I'd like to execute an SSRS subscription after some ETL work run by a SSIS package that takes a varying amount of time completes. I'm considering using this method, which basically consists of SSIS ...
0
votes
1answer
258 views

Access denied to user@localhost

As a root user I did this: GRANT DELETE, SELECT, INSERT, UPDATE, EXECUTE ON dbName.* TO 'user'@'localhost' IDENTIFIED BY 'apassword'; In 'dbName' I created a procedure 'proc_name' with definer set ...
2
votes
2answers
2k views

Creating a database under a different owner

I'm trying to set up a role in Postgres which can a) Create a new Role b) Create a new Database c) Make that new Role the owner of the database d) Have no other rights (as far as is possible!) I have ...
0
votes
1answer
86 views

Why can't I use a cname/alias in the permissions table?

At work we have a usual setup with web server(apache) and database server(mysql). From time to time there is the need to migrate the web stuff to a new server. Lets say their a records are dull and ...
0
votes
0answers
94 views

Grant permissions on stored procedure

I created a user in SQL Server 2012 database and revoked all permissions given by the public role. Then i granted exec permission on a stored procedure. The user can execute the procedure but cannot ...
1
vote
2answers
80 views

User, host, and privileges

In a MySQL 5.6 database I found one user 'foo'@'10.0.0.2' with ALL PRIVILEGES. I also discovered an user 'foo'@'10.0.0.3' granted only USAGE privileges. Does this second user definition make sense? ...
1
vote
0answers
277 views

How to check particular SQL UserID windows permissions in MS SQL SERVER 2012?

I would like to say as per my network system administrative security of windows Server 2012 R2. I am unable to start SQL Server agent. As per in MS SQL Server 2012 , i have "sysadmin" & "public" ...
0
votes
0answers
72 views

Public Role Access For All Users in SQL Server

If I'm not mistaken this comes configured like this by default. Our new DBA stripped this permission and broke ownership chaining. In my mind "public" means "everyone" and hence the permission and ...
1
vote
1answer
2k views

Export all MySQL users

I need export all of a MySQL database users (including permissions) for a migration. There is over 5,000 users, what is the best way to do this? Should I just dump the mysql.user table?
1
vote
2answers
175 views

Maintaining permissions on a replicated view after reinitialization

When we were on SQL Server 2005, there was some way that I was able to keep custom permissions on a view at the subscriber. Now that I'm on SQL Server 2012, there doesn't seem to be a way to do ...
2
votes
2answers
511 views

what is the password to user mongodb when mongodb is installed in ubuntu?

When I installed mongodb in ubuntu, user mongodb and group mongodb are created in /etc/passwd and /etc/group. But I have no idea of the password to these user and group. I have to run mongod as root ...
0
votes
1answer
105 views

SSMS: Limit a login to be able to view and work only with some databases, but not able to make any changes on the server level

On a shared cloud we would like to work with one instance of MS SQL Server. Different clients have various databases. They can be owner of their databases and with DENY VIEW ANY DATABASE TO PUBLIC in ...
0
votes
1answer
1k views

ClearDB Granting Created User Access

I added the ClearDB addon to Heroku, but upon using the created username to create a new database, the error appeared: Executing: CREATE SCHEMA `androidchatterdatabase` DEFAULT CHARACTER SET utf8 ; ...
0
votes
2answers
86 views

MySQL: What exact commands does each privilege level allow?

I am configuring some new logins for users who have already been using the relevant MySQL servers under other logins. I would like to limit their privileges to the minimum each user needs, based on ...
0
votes
0answers
21k views

Grant All privileges on all databases to a Mysql user [closed]

I try to give a user all the privileges on all the databases : mysql> GRANT ALL ON "." TO 'AppBD'@'192.168.1.5' IDENTIFIED BY 'admin'; ERROR 1064 (42000): You have an error in your SQL syntax; ...
2
votes
2answers
201 views

Should new roles be assigned to SYS

Should the user SYS be assigned new roles beside the roles that it has when it was created?
3
votes
2answers
114 views

How can I switch to sa account from guest session in SQL server 2012?

I have a situation where I can log into my server as guest, and see that there is no password on the sa account. However when I try to login as sa with null password over the network it is rejected. ...
1
vote
1answer
121 views

Server-wide Database Permissions in SQL Server

We have a SQL Server 2014 installation, which is accessible by a subset of our Active Directory users via Windows Authentication. Currently, when they log into the server for the first time they are ...
1
vote
1answer
221 views

Create/copy new superuser from an existing one

I have a superuser for a PostgreSQL database, let's call him userX. How can I make a new superuser (let's call him userY) with all the same permissions, access, etc...? Basically, I want a clone of ...
1
vote
0answers
63 views

Problem moving database to new server

I am currently running into two problems. First, when viewing tables using MySQL Query Browser, it keeps displaying "Could not fetch columns". Second, when attempting to go in an edit any of the ...
1
vote
1answer
55 views

Trigger to apply user mapping to logins on database creation [closed]

Does anyone have any example triggers that apply user mapping on database creation?
1
vote
2answers
107 views

Finding AD group permissions source

We have an AD group as a Login in several servers, usually as sysadmin, but I've found one server that this login has no access to any DB and has a server public role only. I've talked to a member of ...
1
vote
1answer
2k views

MySQL workbench: Cannot Connect to Database Server (ssh)

General pointers would be appreciated -- it's likely I'm misunderstanding the mechanisms involved in a remote connection through ssh. I can use ssh to connect remotely, and then, through the CLI, ...
0
votes
1answer
72 views

MySQL - Is it possible to assign permission to count the number of tables in a database without permissions on individual tables?

As part of a script I am trying to count the number of tables that exist in a particular MySql schema. Using my own user I am using the query SELECT COUNT(*) FROM information_schema.tables WHERE ...
0
votes
0answers
51 views

SQL Server 2012 Downgraded from Enterprise to Standard. Permission errors

We downgraded our SQL Server from Enterprise to Standard. Now on 3 of my 5 non system databases a lot of users no longer have effective permissions. My admin account is in the same boat. I have ...
0
votes
1answer
2k views

Grant access to all tables of a database

I recently wanted to share regular access rights with one user of a server and I realized that a simple CREATE USER and GRANT ALL ON DATABASE commands didn't let him run a simple SELECT on the data. ...
2
votes
2answers
86 views

How do I prevent my clients viewing my database definition when it is installed on their server?

I want to give my database to the client to install on their server. However, I want to deny the client rights to see the tables and stored procedures and also want to restrict that database to run ...
0
votes
1answer
51 views

Is it possible to make database owner read only?

The database owner can revoke certain privileges from themselves such as INSERT but is it possible to revoke further privileges such as DROP for read-only operation?
1
vote
2answers
288 views

Oracle: are objects created by sys in a schema the same as objects created by that user?

For example, are there any differences between: SCOTT@ORCL> create index a_idx on a(x); and SYS@ORCL> create index scott.a.idx on scott.a(x);
3
votes
1answer
265 views

Changing db ownership using a user which can only see the sa

At first, I would like to thank the community for creating such a resourceful forum. I've been using StackOverflow for years, and recently, using dba on SE too and you're great. Most of my questions ...
1
vote
1answer
101 views

MYSQL : unable to add privileges to newly created user

I am just trying out Google Cloud SQL. Created a SQL server and white-listed one of my IPs to connect to it. I am able to connect as root@'%' there and do everything I wish, other than granting ...
-1
votes
1answer
873 views

can exec permissions be granted to a role in SQL Server 2008 / 2012

Can exec permissions (e.g. on a SP) be granted to a role in SQL Server 2008, so that all role members then have the permission; and if the 2008 database were backed up and restored into SQL Server ...
0
votes
0answers
438 views

Multiple user roles with different attributes

I need to design a database that has multiple users, with multiple roles. For instance, a user can be an admin, company, employee, or customer. Each user can have any number of these roles. Right now ...
-3
votes
1answer
40 views

How to check table [closed]

How to check which tables a user have access to on a server?
2
votes
1answer
12k views

SQL Server: grant select access to a user in a view and not in its tables

I have a SQL Server 2012 instance with a few databases. In one of them I created a view, that selects tables in more than a database. I want a user to be able to select that view, but it must not ...
0
votes
1answer
54 views

Allow public use of functions without giving them database control

I came up with a set of functions that I would like to be accessed from a variety of places. SQL seemed like the best place for this due to accessibility, but I receive this error when trying to use ...