Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
2
votes
2answers
780 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
687 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
2k 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
162 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
735 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
78 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
173 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
334 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
73 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
435 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
477 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
119 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
192 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
174 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
102 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
118 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
3k 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
507 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
446 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
425 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
575 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
1answer
55 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
54 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
92 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
3answers
747 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
284 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
3answers
80 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
46 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
41 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
629 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
125 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
3k 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
738 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
589 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
78 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
308 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
76 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
175 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
813 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 ...
1
vote
1answer
197 views
MySQL Grant Permission
I want to Grant a user only INSERT permission.
When I try to insert data, it throws the error "Access Denied".
What permission do I give a user to use/select database in mysql and how?
I have given ...
1
vote
0answers
1k views
Error Authenticating Proxy Account when Executing SSIS job
I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages.
These packages have been running for years and the associated steps run via a Proxy Account ...
1
vote
2answers
564 views
Can I restore the defult SQL Server Public Role?
I setup a new user login and attached it to a specific database on my server. I then opened up management studio on my local pc, connected to the database using the server IP and selecting the ...
0
votes
1answer
58 views
How to deny access to see the logins in a database
I create a login in SQL Server 2008 R2, and when that user connects to a database, it can see all the logins in the security logins. Can I deny access to watch the logins of the database?
0
votes
4answers
250 views
Unable to access mysql database remotely
I ran this command-
[root@dev-img mysql]# mysql -u root -h 192.168.1.181 -e "use mysql;"
and this is the output I got-
ERROR 1045 (28000): Access denied for user 'root'@'192.168.1.65' (using ...
