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)

2
votes
3answers
4k views

Oracle “Import from Export Files” screen refusing both SYSADMIN and Normal users

I have just installed Oracle 11g on Win64, and I want to import some .dmp files. I am trying with the tool Oracle Enterprise Manager 11g: If I log in with SYS as SYSADMIN, and go to Import from ...
2
votes
1answer
37 views

Permissions on Trigger Problem

I am working with a database in MS-SQL 2008 R2, and I'm running into a problem. The basic setup is this: There are two tables of interest: dbo.Assesments and audit.Assesments. dbo.Assesments is the ...
2
votes
1answer
53 views

stored procedure can select and update tables in other databases - minimal permissions granted

I recently had to make the stored procedure spPartyOrderAllocation_AllocateItems to select and update tables in other databases, while keeping the pemissions levels to the minimum. This was ...
2
votes
1answer
122 views

Teradata 15: Failed [5315 : HY000] An owner referenced by user does not have SELECT WITH GRANT OPTION access to DBC.RoleMembersV.RoleName

I am using Teradata 15. Using a powerful database user sysdba, I created the following view: REPLACE VIEW DBA_TABLES_TEST.ROLE_ALL_APP_USERS AS SELECT A.ROLENAME FROM DBC.ROLEMEMBERSV A ...
2
votes
2answers
23 views

Most restricting permissions for querying view with linked server

I've created view to query another server via linked server(SQL Server 2014). I need to grant permissions to developers to use this view. Granting only select is not enough and they got the ...
2
votes
1answer
36 views

Find signed procedures, functions, triggers, assemblies and by which certificates / asymmetric keys

I have created a few Certificates (via CREATE CERTIFICATE) and Asymmetric Keys (via CREATE ASYMMETRIC KEY) and used them to sign and counter-sign various Stored Procedures, User-Defined Functions ...
2
votes
1answer
53 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 ...
2
votes
1answer
312 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. ...
2
votes
1answer
157 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 ...
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 ...
2
votes
1answer
1k views

Are the ALL_OBJECTS and DBA_OBJECTS different when you have DBA Role?

I am trying to fully understand the difference between ALL_OBJECTS and DBA_OBJECTS. I am still new in Oracle and get confused by the whole Access/Roles thing. From here: ALL_OBJECTS shows all ...
2
votes
1answer
5k views

Cannot start psql with user postgres “Could not change directory to /home/user ”

I did a silly mistake. I wanted to set postgres permissions to a folder for exporting data from my database. So I set something like sudo chmod 777 -u postgres /home/user and then my home partition ...
2
votes
1answer
3k views

MySQL Mistake with GRANT OPTION

I am unsure reading the MySQL documentation if creating a user with the GRANT option will give them the power to create users and grant privileges, or change the privileges of other users databases. ...
2
votes
2answers
1k views

Stored Procedure against Linked Server

We have an AX server that we would like a group of users to be able to retrieve data from but limit their access to just the data needed. Normally this could be done with a stored procedure and give ...
2
votes
2answers
151 views

MySQL Security permissions

Is it possible in MySQL to block users from executing these statements? DESC "table" SHOW TABLES SHOW CREATE TABLE "table" Or I need to write a MySQL transport port wrapper ? GRANT ON TABLE does ...
2
votes
1answer
237 views

GRANT privileges to table elements

What happens if I GRANT priveleges (for example SELECT) ON a table TO some group role? What privileges will the table's elements have in this case: indexes, sequences, columns? Should I explicitly ...
2
votes
4answers
174 views

SELECT Statements only please

I have a user that wants to use SQL Server Management Studio (SSMS) to run SELECT statements. I don't want him to be able to modify data. I can't regulate his permissions through Windows ...
2
votes
1answer
238 views

Active Directory domain being shutdown— Do I have to update my DBO accounts?

I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
2
votes
1answer
3k views

SQL admin Scripts - Enabling read only access to all databases

I would like a script that will allow our web developers read only access to all databases on our SQL server. Currently we are having to do this manually as we have no SQL expert / DB Admin. Would ...
2
votes
1answer
10k views

Oracle: what permission is necessary to “grant create table” to another user?

What permission should A have in order to grant B permission to create a table? logged in as user A, I execute grant create table to B; and receive the following error: SQL Error: ORA-01031: ...
2
votes
1answer
2k views

How to make it impossible for a postgres user to delete databases?

What yould be the sql statement (that the user postgres will execute) so it will be impossible for the postgres user user1 to delete (drop) databases? Or can I add a rule into some config file?
2
votes
1answer
4k views

One MySQL user from 2 hosts not on same subnet

I've googled around for this with no luck. I have a master database with one slave. The perms for the slave are set and it runs fine. I'd like to add another slave using a clone of the original ...
2
votes
2answers
35 views

How do I detect execute permission granted to a role (when no ON clause was used)

I just spent hours trying to figure out how an app had privilege to execute stored procedures. TIL from StackExchange: Turns out the ON clause is optional for GRANT, allowing a role to be granted ...
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 ...
2
votes
1answer
164 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
2answers
79 views

How to identify database users and their owned schemas before dropping server logins?

While deleting logins, there might be a possibility that there are users in databases along with chances that they own schemas in those databases. Is there a way to find this out with a single ...
2
votes
1answer
39 views

What should be the command for following role creation requirement?

I need to create a role where the assigned user can access only the 'AdventureWorksDB" where he will have execute permission to all tables,views and stored procedures in the database. I wrote the ...
2
votes
1answer
131 views

Unable to remove permission for mysql.user

I am trying to remove permission from mysql user to not be able to delete specific database. But if i run this command: revoke all privileges on test.* from 'demo'@'localhost'; or this revoke drop ...
2
votes
2answers
115 views

DENY access to EXEC for a role

I have a read-only database user that I do not want to be able to run the EXEC command. I ran the following: DENY EXECUTE to db_USERROLE_deny That completed successfully; however, when I sign in as ...
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 ...
2
votes
1answer
2k views

How to list the permissions on User-Defined Table Types?

I am using some user-defined table types. They are very useful. you can see information about them by running this simple script: SELECT o.* from sys.table_types o I have a procedure that shows me ...
2
votes
1answer
6k views

Domain Admins can't connect to SQL Server

I have a Windows Server 2012 R2 domain controller and a database server (W2K12R2/SQL Server 2012). As allowed usergroup I have given the group "domain-admins" sysadmin rights. But somehow any ...
2
votes
1answer
921 views

Has some command that lists the privileges of a user in db2?

I'm using db2 9.7 on linux and i want to list my privileges on database... Ex: SYSADM, SECADM, DBADM, etc. So, has some command in db2 that lists the privileges of a user in db2?
2
votes
2answers
165 views

How to control access security in database [closed]

Our database's security became a problem recently. Here is what we have: Several basic roles - read_only (select, view definition) read_write (insert/update/deleted) executor (execute SP/function) ...
2
votes
1answer
124 views

MySQL GRANT requiring additional permissions

I have a MySQL user (rundeck) that is being used as part of a deployment process. Its purpose is to create a new database, create a new user, and grant permissions to the new user for the new ...
2
votes
1answer
8k views

How to grant permissions for User defined type in Oracle

This is probably easy but i can't seem to figure it out. I created my user-defined type as CO_ADMIN. However, the application using the type runs using GS_USER database account. I have granted ...
2
votes
1answer
205 views

Does PostgreSQL allow multiple grantees in GRANT commands?

Looking at the PostgreSQL docs it seems that the GRANT command only grants to a single user or role. In fact it doesn't seem to be PostgreSQL alone. Isn't possible to do something like GRANT SELECT ...
2
votes
2answers
825 views

MySQL user without SUPER privilege

This may be a simple question and may not be the right place to ask but I couldn't find any useful information from Google. Here is my question. When creating users in mysql using grant all ...
2
votes
1answer
205 views

How to create a role that cannot create or alter a table?

I want to create a role named manager in postgresql . This role can update, select, delete and insert data in all tables but users that belong to this role cannot create a table nor modify the schema. ...
2
votes
1answer
3k views

Mysqld can`t start after I changed the socket path

here is the log 131229 14:55:27 [ERROR] Can't start server : Bind on unix socket: Permission denied 131229 14:55:27 [ERROR] Do you already have another mysqld server running on socket: ...
2
votes
1answer
4k views

Which user does Windows Authentication of a maintenance plan authenticate? before whom, why and for what?

I am having a maintenance plan configured with Windows Authentication being run by an SQL Server Agent job with owner sa Whom does Windows Authentication of a maintenance plan authenticate, ...
2
votes
2answers
2k views

Oracle's UTL_FILE when connected locally or through listener has different behaviour

We have a procedure which creates a CSV file with UTL_FILE. (env is Oracle 11.2.0.1 and RHEL 6.4) Until now, we were storing that CSV file into system oracle (the oracle owner) user home ...
2
votes
2answers
6k views

Permissions Needed To Attach AdventureWorks Database

I am trying to add the AdventureWorks database in MS SQL Server Management Studio (SSMS) 2008 R2. As a new person to this area, or noob, this seemingly simple task has caused me much hardship and ...
2
votes
2answers
2k views

One database with two schemas: cross-schema View permissions issue?

I have a database on SQL Server 2008 R2 that has two schemas, the default dbo and a new one called Test. I have a view in the Test schema called View1 that selects from dbo.Table1. Both schemas are ...
2
votes
1answer
2k views

SQL Server 2005 Easy way to add all users to a database role

I have three application databases: A, B and C. Users of A and B are all users in C; the users from A are in the public role with only SELECT permission, while the users from B are in a role with more ...
2
votes
1answer
39 views

How do you properly remove “REQUIRE SSL” from a single user?

I successfully granted REQUIRE SSL to a single user by doing... mysql -u"${targetMySqlUser}" -p"${targetMySqlPass}" -e "GRANT USAGE ON dbname.* TO 'dbusername'@'%' REQUIRE SSL;" but im failing on ...
2
votes
1answer
89 views

Grant select on all synonyms of schema to another schema in Oracle

I need to write a query for granting the select privilege to all synonyms and tables of one schema to another schema in Oracle. Example: Admin schema has all the tables. I want the User schema to ...
2
votes
1answer
77 views

How can I create a role to create,update,delete stored procedures and views

what permissions do I need to give in order to achieve the above task to get users the capacity to create,update,delete stored procedures and views to a database role.