Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
3
votes
0answers
175 views
Deny view definition at DB level and symmetric keys MS SQL Server 2005
I don't want a restricted database role to be able to view table and stored procedure definitions and code.
So I do
deny view definition to some_db_role
It does appear though that this is not ...
2
votes
3answers
90 views
What tasks can only sysadmin's do in SQL Server 2000?
I'm cleaning up permissions on my SQL Server 2000, and I want to verify that a particular account still has sysadmin privileges.
What non-destructive tasks can only sysadmins do that I can use to ...
2
votes
1answer
91 views
Attaching a database in SSMS gives error
I am accessing SQL Server using SSMS, and a user with adequate permissions.
When this user tries to attach a database by using SSMS (by right clicking on database node and then clicking on attach), ...
2
votes
2answers
1k views
SQL Server 2008 linked server to an Access 2007 DB that is in a protected directory on the Network
We have a SQL Server 2008 database that we are attempting to link with an Access 2007 DB (the maintainer works down the hall and refuses to migrate to SQL Server). We have the password to the database ...
2
votes
2answers
811 views
Set permissions on a view
I'm creating a view on a SQL Server 2005 database via SQL Server Management Studio 2008, the view reads from two tables. The view is accessed from a web application and I want users to be able to ...
2
votes
1answer
728 views
Possible to detach a database from SQL Server while retaining file permissions?
When a user detaches a database from MS SQL Server, it sets the owner of the data and log files to that user. It also removes all non-owner permissions from the files. This is partially explained at ...
2
votes
2answers
3k views
mysql: Show GRANTs for all users
MySQL's SHOW GRANTS shows the permissions of the current user.
Is there a way to log in as root and show the permissions of all users?
2
votes
1answer
166 views
unreachable SQL Server for a group of computers
I'm deploying SQL Server 2008 Express in my company. I already installed, did a application, tested, gave permission to user.
All desktop users run the program without any problem. But the notebook ...
2
votes
3answers
749 views
SQL Server Permission Denied Error When I'm DBOwner?
So I created an account, gave him dbcreator and securityadmin privileges and then through that account tried to run CREATE TABLE on a database that I had created and now owned, but was getting a ...
2
votes
1answer
85 views
SQL 2008: Why is *any* user, with minimal permissions able to restart/stop the SQL instance through Management Studio
So I'm on a project that I need to help admin SQL 2008 .
I'm coming from a MySQL background.
Why is it that a basic user, with the most basic/default permissions, through Management Studio is able to ...
2
votes
1answer
1k views
Oracle permission issue
Please see the following statements. My question is, the table t1 was created in the users tablespace, so it will take up some space. But why it can be created before I impose the quota on the users ...
2
votes
1answer
177 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
365 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
1k views
How do I install pgcrypto on Windows?
I would like to install pgcrypto in Windows. I have a file C:\Program\PostgreSQL\9.0\share\contrib\pgcrypto.sql but when I try to run it in psql I get an error:
C:: Permission denied
How do I solve ...
2
votes
1answer
96 views
Even when user has 'bulkadmin' role, query says user does not have role - SQL Server 2012
I am facing a weird issue with SQL Server 2012.
I have a user (say RS\sqluser) which has bulkadmin role.
Now when i run this query
Select IS_SRVROLEMEMBER('bulkadmin', 'RS\sqluser')
output is 0. ...
2
votes
1answer
653 views
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself
I encounter the following error:
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
when I was trying these commands
USE ASPState
GO
GRANT ...
2
votes
2answers
502 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
5answers
122 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
2k views
MySQL user permission on stored procedure
I've created a simple stored procedure:
mysql> CREATE FUNCTION hello (s CHAR(20))
-> RETURNS CHAR(50) DETERMINISTIC
-> RETURN CONCAT('Hello, ',s,'!');
Query OK, 0 rows affected, 1 ...
2
votes
1answer
1k views
CREATE DATABASE Permission denied in database 'master' error
I'm working with a tool that as one of the automated steps will attach databases from my file system to my local SQL Express 2008 instance. The tool requires a login in the sysadmin server role, for ...
2
votes
1answer
201 views
How to grant permission for am administrator account in SQL Server 2012? [closed]
I installed SQL Server 2012 on my laptop. I am trying to run a script to create a simple database.
SQL Server version: 11.0.3128
SSMS starting parameters:
server type: database engine
server name: ...
2
votes
2answers
255 views
How to refresh AD security group on Sql Server permissions
I am using Sql Server 2008 on Small Business Server 2003; client is using WinXP.
I added a user to my Active Directory Security Group; Why can't this user immediately access the database? It seems ...
2
votes
1answer
118 views
Monitor user to query processlist
We have a corporate monitoring system based in Zabbix. Its MySQL monitoring is quite basic, so I want to add more info. To do so, I've done a script that retrieves this info from MySQL and sends it to ...
2
votes
0answers
126 views
Oracle sqldeveloper Database Diff - not seeing indexes/sequences
I am using Oracle SQL Developer's database diff tool to compare schemas. (SQL developer version : 3.2.09) It works great on some environments, but in one, I can only see differences in tables - the ...
1
vote
3answers
4k views
When creating views, why do users need direct object permissions if they already have the same permissions via a role?
I'm having a problem with permissions in Oracle 10g. I'm hoping someone can help me make sense of this.
I have a schema with a table in it. I have granted select on that table to a role.
grant ...
1
vote
2answers
572 views
In Oracle, how can I give one user privileges to alter the schema of another user?
I have an Oracle DB (10.2), and I have a consultant (Dogbert) that I want to do some work on it. In particular they need to alter the table structures of tables in a schema (we'll call it Wally) that ...
1
vote
2answers
490 views
Move (Restore) SQL Server 2005 database which does not exist before
I did not ready about this but found out after trying to restore a database from remote server and it wont restore if the database did not exist before. What I would do is
create a .bak file ...
1
vote
2answers
429 views
Granting permission to SQL database
How do you grant a user xp_cmdshell, sp_OACreate, sp_OAmethod, and sp_Destroy on SQL server 2008? What is the prons and cons of granting this permission? Please let me know. Thank you!
1
vote
1answer
599 views
Executing a stored procedure on remote database
I have 2 databases on the same server. DB-A and DB-B. DB-B has a user that has read and write access to database B. I would like to grant the user in DB-B execute permissions to 2 stored procedures in ...
1
vote
3answers
761 views
SQL Server : Execute as multiple users simultaneously?
I need to query a proprietary database where the software vendor has set tight permissions on each schema (one username per schema), and each schema-user is only allowed to read from their own schema.
...
1
vote
1answer
61 views
SQL Server 2005 encryption - What Grants should I give
I use Mixed mode Authentication and I want my database users (in the Public role membership) to have the ability to JUST execute procedures that encrypt/decrypt data (using Certificate and Symmteric ...
1
vote
1answer
56 views
In Oracle, will certain users only be able to see certain data in the privileges tables?
I can view data in the table_privileges view logged in as a particular user, but it seems to be missing or different information when logged in as a different user.
For the privileges views (data ...
1
vote
1answer
96 views
mysql: show which users have permissions to a DB
Is there a way to show all users that have permissions on a database?
I'm looking for something like:
> show_permissions_for_db <DB>;
+----------+----------------------+
| User | ...
1
vote
1answer
290 views
Giving selective permissions in a database
I have a user [AD\dbusersgroup_limitedrights] that should have on two schema's
[ICD] and [XCD] within a database only SELECT and EXECUTE rights, however for each of the users in the ...
1
vote
2answers
43 views
Where should I look for details about 'access denied' errors?
This question derives from Deploying a new database on a new server, an msbuild ssdt rookie issue.
Since I have a permission denied error, I expect to find which user is failing to access so I can ...
1
vote
3answers
161 views
Database user permissions: GRANT VIEW DEFINITION but DENY on some object types
I'm trying to figure out a combination of permissions that will allow a partner to see basic db schema but not expose objects including code. So,
VIEW and SELECT on TABLES (including keys)
...
1
vote
3answers
52 views
MySQL Permissions
A web application that we're working on creates a new database for each user that signs up.
With this, I'm setting up a database user for each of these new databases and wonder what the best ...
1
vote
1answer
58 views
Permissions for a MySQL user which will monitor replication status?
I'd like to use a script to monitor the replication status of a MySQL database like in this bash script: https://gist.github.com/wesdeboer/1791632
I'd like to create a user which will only be used to ...
1
vote
2answers
766 views
SQL Server 2008R2 - How to prevent a role from creating or altering views within a database?
I have a situation on SQL Server 2008 R2 where I am trying to prevent users of an AD group from being able to create new views, or alter any existing views, within a particular database. This AD group ...
1
vote
1answer
128 views
Whitelist-based SQL Server schema setup
My group has access to a single database on a SQL Server instance. We have a number of different people in our group, each working on separate projects. In trying to determine how to segregate ...
1
vote
1answer
4k views
How do I grant execute permission to an Oracle database user?
I'm trying to call a Java function from Oracle database that does the following:
Process p = Runtime.getRuntime().exec("...");
When I try to run it, I get the following error:
ORA-29532: Java call ...
1
vote
1answer
3k 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: ...
1
vote
1answer
749 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 ...
1
vote
1answer
628 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 ...
1
vote
2answers
95 views
Can SQL Server 2008 / 2012 have execute permission in a function for a user, but not for a table used in the function?
I have a function that returns a table. This function SELECTS DB1.dbo.table1
user1 has SELECT permission in this function only, but when selecting from the function error comes up stating that the ...
1
vote
1answer
369 views
Permission denied in file trying to import
When I try to use \i on a file that is not in the psql.exe folder it says C:: permission denied. For example I have a file with SQL command at C:\Users\Work\Desktop\School Work\load_database.sql and ...
1
vote
2answers
79 views
Cannot INSERT into database on a shared server
I have launched an application on a shared server but I cannot INSERT any data. I thought maybe I don't have privileges so I did SHOW GRANTS in my application then die()
The result was [ EDITED ]:
...
1
vote
1answer
183 views
Users groups/permissions when working with PostgreSQL
While I've been working with PostgreSQL for approximately 1 year, I still feel like a bit of a Newbie. I feel like I'm constantly fighting with psql and pg_dump when it comes to files and ...
1
vote
1answer
78 views
MySQL GRANT control
How can I write a script to automate MySQL database grants in a very easy way?
I have a config file that contains the grant changes I want to make. I want the script to read the config file, and ...
1
vote
2answers
825 views
Allow db_owner to add/view existing logins to database
On our development server (SQL 2008 R2) we want local dbo's to be able to add existing logins on the server to the database. The problem is they can't view them, they can only see themselves in the ...
