Stack Overflow
Stack Overflow

Questions tagged [database-permissions]

238 questions
1
vote
0 answers

Restore SQL Server database to different server with non sysadmin user

I'm trying to restore a database from a backup into a different server using an user that is not sysadmin (with dbcreator server role). According to this: http://technet.microsoft.com/en-us/library/ms190436(v=sql.105).aspx the user that restores the…
nflash
  • 430
  • 3
  • 16
1
vote
2 answers

Check permission to a table

I am currently making a vb.net program that needs to check permissions on a table (if the table does not exsist, then the permission on the database, if the database does not exsist, then the permission to the sql server) is there a way to check…
Droa
  • 427
  • 7
  • 15
1
vote
2 answers

Restrict user to Stored Procedures

I need to restrict user access to SELECT, INSERT, UPDATE and DELETE, so that user should manage data only using stored procedures I provide. So, for instance SELECT * FROM Table1 should return The SELECT permission was denied on the object…
adontz
  • 1,428
  • 16
  • 36
1
vote
1 answer

Verify my permissions in a MySQL database (or table)

In my job, I've been granted access to several databases, but not the same degree of liberty for each of them. A few minutes ago, I was attempting to make an UPDATE operation and I got this error message: Error Code: 1142. UPDATE command denied to…
Clawdidr
  • 577
  • 1
  • 8
  • 25
1
vote
1 answer

Why are these DMVs returning rows for all databases except one?

I am trying to query the DMVs in SQL Server 2008 R2. On this server are two user databases called histrx and OpenLink. To prove I have their names correct: select db_id('histrx') -- Returns 5 select db_id('OpenLink') -- Returns 7 If I run the…
Sir Crispalot
  • 4,792
  • 1
  • 39
  • 64
1
vote
2 answers

General error: 1 Can't create/write to file errcode:2

I am trying to write a CSV file to /var/www/VistaMind_CMStmp and I get the error Message: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/VistaMind_CMS/tmp/app_users.csv' (Errcode: 2) I tried doing chown mysql:mysql…
Sonu Jha
  • 719
  • 3
  • 13
  • 23
1
vote
1 answer

User has permissions problems with SPROC even after granted permissions to all DB items

The MetricsUser account receives the following error when executing a stored procedure: "Msg 1088, Level 16, State 7, Procedure Data_SPROC, Line 59 Cannot find the object "tblPeopleProjectStage0" because it does not exist or you do not have…
Shrout1
  • 2,497
  • 4
  • 42
  • 65
1
vote
2 answers

database permissions match whoever is running PowerShell script instead of those specified in connection string

I want SQL Server permissions to conform to the ID I specify in the connection string, NOT those of whoever happens to be running the PowerShell script (usually me). For example, I have a table called “MyTable” which I can update but which…
user2267792
  • 13
  • 3
1
vote
2 answers

MySQL Grant permission based on column value?

I am trying to grant access permissions to a certain user who has 'manager' access. They are able to SELECT and UPDATE but only to the people in their own group. The DB is redflame and the table is payroll. A portion of the table is…
jarsever
  • 690
  • 1
  • 7
  • 15
1
vote
1 answer

How to add SQL LocalDB permissions

I.. "accidentally" removed my database permissions for my windows login to localdb Any idea how to give permissions back to that database?
jaekie
  • 2,283
  • 4
  • 30
  • 52
1
vote
0 answers

RAISERROR with >20 Severity and Database Permissions

I'm attempting to deploy an INSTEAD OF trigger to a Sql Azure db. Among other things, it can potentially execute the following line: raiserror('error text', 20, 1, @somevar) with log; Anything with a severity greater than or equal to 20 in Sql…
Dusda
  • 3,347
  • 5
  • 37
  • 58
1
vote
4 answers

SQL Server 2012 - File table permissions for network access

I have a sql server 2012 instance set up as a filestore on a networked server. I need all users on computers on the same network to be able to browse the file system representing the file table. However all user can see the server, and top level…
Dpolehonski
  • 948
  • 6
  • 11
1
vote
2 answers

java.sql.SQLException: Access denied for user 'xx@xx.xx' (using password: YES) appearing 2 years after installation

I started getting java.sql.SQLException: Access denied for user 'xx@xx.xx' (using password: YES) from a servlet when trying to add new data to a database. Irrespective of the error, the data still gets written to the database. The database has…
method8
  • 21
  • 1
  • 2
1
vote
1 answer

How do I execute a procedure in a package I just created in another schema?

Setup: I have two trees of scripts that run on Oracle 11g - one set ensures the correct instance configuration and that all of the DBA proxy accounts are there to connect to the dbadmin account, and the other set builds and modify our database…
Thought
  • 700
  • 2
  • 9
  • 21
1
vote
3 answers

Database Permission Structure

Many of my employers applications share a similar internal permission structure for restricting data to a specific set of users or groups. Groups can also be nested. The problem we're currently facing with this approach is that enumerating the…
Alex
  • 811
  • 2
  • 11
  • 23
1 2 3
…
15 16