Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
2
votes
1answer
68 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), ...
5
votes
1answer
66 views
SA permissions issues with many nested objects
I have a broker application that's relatively complicated.
Today, after I made some changes, I started getting the error:
The server principal 'sa' is not able to access the database 'XYZ' under ...
3
votes
1answer
27 views
How should permissions for anonymous users be modelled?
I'm designing a web application. There will be users who log into the site, but also anonymous, non-authenticated users, i.e. any member of the public who accesses the site. Users will be assigned to ...
0
votes
0answers
27 views
EXECUTE AS over Linked Servers
I have a front end that logs into the DB as "logInA", and only has permission to "schemaA" stored procs, which use EXECUTE AS "logInB", (I have also tried EXECUTE AS 'DBO'), to handle all the business ...
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 ...
0
votes
0answers
23 views
Trouble with ACE.OleDB.12.0 connection across domains
Here is the situation:
I have two servers, for simplicities sake we'll call them database-server and website-server.
The database-server is to hold an Access database that we're using during ...
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 ...
0
votes
1answer
29 views
Add user to sql server with the required permission
In my sql server express 2008 r2 i have about 15 login account. Now i want some about 5 users have full permission while some other 5 users with limited access to some database, and other users only ...
1
vote
3answers
93 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)
...
0
votes
1answer
59 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
1answer
51 views
Executing sys.dm_fts_parser without sysadmin server role
A web application needs to execute sys.dm_fts_parser to discover which words SQL Server Fulltext Search used to match documents for the purpose of syntax highlighting. That stored procedure can only ...
2
votes
1answer
76 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. ...
1
vote
3answers
48 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 ...
0
votes
1answer
29 views
Giving permission for each table within a database
I want to give different permission for different tables within a single database for a user.For example a user has full permission to a table while for another table only read permission.How it can ...
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 ...
4
votes
2answers
119 views
Track grant permission on tables
I'd like to see if there are any changes on the permissions granted for a specific table.
For example, I don't want to have the login 'John' have the SELECT permission on the table Invoices.
If ...
0
votes
1answer
133 views
Granting permissions only on a set list of objects
I have a SQL Server 2005 database with a large number of tables in the dbo schema. I now created a new schema (call it myschema) that only has three table-valued functions and two stored procedures in ...
1
vote
1answer
42 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 ...
2
votes
1answer
195 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: ...
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 ...
2
votes
2answers
176 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 ...
0
votes
1answer
171 views
Why is a new user allowed to create a table?
I'm wondering why a newly created user is allowed to create a table after connecting to a database. I have one database, project2_core:
postgres=# \l
List of ...
2
votes
1answer
457 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 ...
0
votes
0answers
58 views
How to do point in time recovery of binary log files into .sql file
I have written a shell script to do an incremental backup of MySQL database.
For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory.
For point-in-time recovery, Im ...
3
votes
1answer
196 views
SQl Server 2008 R2 - sa can login but not access database
Up until this morning I had no problems accessing our database.
This morning, something has changed and I can no longer access our database (called EMS_Main) using the sa login. I can log into the ...
2
votes
1answer
106 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 ...
4
votes
1answer
127 views
SSRS appears to be ignoring Permissions set using Report Manager
I have setup SSRS on SQL Server 2008 in native mode.
As an administrator I can login to report manager, upload reports and run them, and also use the Web Service URL to generate reports.
I have also ...
5
votes
1answer
142 views
Steal ownership on database from user that no longer exists
We have a few SQL Server 2008 R2 databases where its member domain was changed (i.e. it was connected to DOMAINA and is now on DOMAINB). We have three databases where the owner of the database is ...
3
votes
1answer
352 views
Does this mean the 'public' has full select, insert, update, and delete access?
I'm trying to create a new DB user in SQL Server 2008 R2 that can only select from one SQL View. But no matter what I try when I login as this new user I can select from any table. I ran this query: ...
5
votes
1answer
120 views
SQL Server Security Hierarchy
I have been working as a developer with SQL Server for years without asking the question, "what is dbo", a shame. Recently I have been studying the security model of SQL Server 2008. I have been ...
0
votes
4answers
259 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 ...
3
votes
2answers
176 views
Get the windows account which runs the query?
I'm using sql server 2008 r2.
I logged in to ssms which in turn connects to a remote sql server machine.
im writing a query which writes a file.
I need to know - which windows permissions I should ...
1
vote
2answers
641 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
313 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 ...
7
votes
3answers
255 views
Identify why a user can drop a database
I have a sql server user that has the ability to drop any database. I've been running the code below to check the rights that the user has in SQL Server but have not been able to identify how the user ...
1
vote
2answers
77 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 ]:
...
4
votes
1answer
3k views
PostgreSQL: permission denied for relation
I'm a bit confused about setting permissions in PostgreSQL.
I have these roles:
List of roles
Role name | Attributes | Member of
...
0
votes
1answer
102 views
How to test permissions on an empty database?
It's usual in an organization I work in that I need to request a database creation to the DBA group (I am a developer). As such, they will also create a user for me to use and a database dedicated to ...
4
votes
1answer
114 views
Managing Access for DBA and IT Support
We are currently in the process of moving our development, test and live databases on to separate servers and instances and I am looking at how best to manage access for DBA tasks and also IT Support ...
3
votes
1answer
697 views
How to grant a user UNSAFE ASSEMBLY permission
How can we assign a user , e.g.: the database owner (DBO) the UNSAFE ASSEMBLY permission?
I'm asking it to enable a user to create an assembly and don't know the SA password, so EXEC sp_changedbowner ...
3
votes
2answers
649 views
Users cannot view tables in non-default schema in SSMS
I'm having an issue setting the VIEW DEFINITION permission appropriately at the schema level for one of my users. I've created the schema TestSchema and added some tables. The user currently has ...
2
votes
2answers
478 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 ...
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 ...
0
votes
1answer
131 views
MySQL '%' hostname wildcard
I've used the following to grant all privileges on mydb to myusername:
GRANT ALL PRIVILEGES ON mydb.* to myusername @'%' IDENTIFIED BY 'mypassword';
I thought that the % is a wildcard for all ...
4
votes
2answers
171 views
Enumerate drives available to SQL Server
I'm trying to work out a way of listing the drives that a particular instance of SQL Server is "aware" of, and understand the process.
I can run EXEC master..xp_fixeddrives which gives me a list of ...
3
votes
2answers
353 views
User can alter procedures without permission
I have a sql server user that our application is connecting as. The user has been granted db_datareader and db_datawriter as well as Grant Execute on each stored procedure that it needs to use.
...
1
vote
1answer
177 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 ...
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 ...
3
votes
2answers
1k views
Select permission inside stored procedure?
I have granted a user execute permission for a stored procedure through SSMS, but when he tries to execute it, he gets the error:
The SELECT permission was denied on the object '[table name]', ...
5
votes
2answers
95 views
Will a SP which writes records fail if accessed by a db_datareader role?
I have a stored procedure which is accessed remotely by an app which is running on some kind of Java/WebSphere type platform. It takes one argument, returns some data and that's that.
Recently there ...
