Stack Overflow
Stack Overflow

Questions tagged [database-permissions]

238 questions
1
vote
1 answer

Permission denied to SET SESSION AUTHORIZATION on Amazon Postgres RDS

For my application, I sometimes need to set session authorization to execute certain commands under a given user's permissions. We're using an RDS behind the application, and our DB superuser on RDS keeps getting permission denied to set session…
Noah
  • 1,608
  • 15
  • 31
1
vote
0 answers

SSIS permission issue with views

I would like to read a view within a SSIS package. Yet the package fails with the message: "Syntax error, permission violation, or other nonspecific error". The SSIS package is executed by a SSIS Package Execution proxy with the intend to limit the…
Jennifer Fuss
  • 43
  • 10
1
vote
0 answers

SQL and Active Directory groups, Schema permissions

I have the following problem, we assign perms in SQL 2014 using ad groups. we have the following l_sql-db-demodb-dbo: this is a local group where we assign the actual permission (dbowner against 'demodb') g_sql-db-demodb-dbo: global group…
dogfish182
  • 35
  • 6
1
vote
2 answers

Configure CouchDB as read-only for non-admins

I recently set up CouchDB on my server, but I'm running into a lack of information regarding changing permissions. I have an admin account, so it's not an admin party, but the restrictions are still looser than I'd like. I'd like the Futon interface…
Luke Taylor
  • 8,631
  • 8
  • 54
  • 92
1
vote
0 answers

Remove all non default permissions from a SQL Server database

I have messed up a SQL Server database that I need to delete all permission on. I need to keep the built in permissions. What is the best way to handle this? Is there somebody with a script out there? Or is possible to restore a database without the…
Johan Bertilsdotter
  • 676
  • 6
  • 23
1
vote
4 answers

SQL Server: protect database from being changed directly

Our program ships with an SQL Server 2005 database and SQL Server 2005 Express. Usually it installs its own instance of SQL Server 2005 in the client's computer. Now I have to add some tables whose content should only be updated from within the…
djeidot
  • 4,542
  • 4
  • 42
  • 45
1
vote
2 answers

Grant all tables (except 1) Read permission on a Role while not knowing which tables there are every day

Every day in our datawarehouse (that will be dynamically changing) the tables are dropped and rebuilt. Also is it possible that some developer in our organisation will create more tables in that database. Because of that I can not give permissions…
Ronald
  • 13
  • 1
  • 7
1
vote
2 answers

I can't create a view in oracle database using sqlplus (insufficient privileges)

I'm running this SQL: CREATE VIEW showMembersInfo(MemberID,Fname,Lname,Address,DOB,Telephone,NIC,Email,WorkplaceID,WorkName,WorkAddress,WorkTelephone,StartingDate,ExpiryDate,Amount,WitnessID,WitName,WitAddress,WitNIC,WitEmail,WitTelephone) AS SELECT…
Nubkadiya
  • 3,285
  • 13
  • 40
  • 45
1
vote
2 answers

Database permissions and ORMs

I've been using .NET's Entity Framework a lot lately and have absolutely no wish to go back to using Stored Procedures. Been shocked though that the company I'm building this project for had a policy where applications were only given accounts that…
Jonn
  • 4,599
  • 9
  • 48
  • 68
1
vote
1 answer

Restricting View Permissions

I created a user with db_dataread permission and I want to make sure the user can only run views and not see the script to how the view was created. What is the best way of doing this. I want to make sure I have all the angles covered and make sure…
Djbril
  • 745
  • 6
  • 26
  • 48
1
vote
1 answer

Classic ASP - Which user needs execute permissions granted for stored procedure

I have a classic ASP application running under IIS (v8.5.9600) on Windows Server 2012R2. One of the pages makes use of a file upload control that allows a user to upload a data file to be processed by the system. Once the file is uploaded a stored…
webworm
  • 10,587
  • 33
  • 120
  • 217
1
vote
0 answers

PHP PDO connection to remote server connects to local server instead

I am wondering when I instantiate a new PDO object it still uses the local IP of the server. It gives me this…
kapitanluffy
  • 1,269
  • 7
  • 26
  • 54
1
vote
2 answers

How to give permission to rename a database sql-server

I have a user who needs to rename a database. I could give dbcreator privileges, but this would allow the user to rename any database, and even create new ones. So I tried to create a stored procedure that the user would call to do the job. CREATE…
Yves Forget
  • 101
  • 3
  • 10
1
vote
4 answers

SQL Server - Limit the databases view based on login

I have a situation where I want to limit the database view per user login. For example: I have 3 databases in my SQL Server instance called MyDB, UserDB, RestrictedDB. I then create a 2 logins; User1 and User2. I then did a DENY VIEW ANY DATABASE…
Jaime
  • 595
  • 1
  • 8
  • 20
1
vote
1 answer

MS SQL Server - Database Sysobject table missing permissions?

I'm going trying to fix an issue that is burning and I've spent the last day without success. I have a database server running SQL Server 2008, one database and one stored procedure. The stored procedure logic contains the following sentence: IF…
G21
  • 1,297
  • 2
  • 18
  • 39
1 2 3
…
15 16