Stack Overflow
Stack Overflow

Questions tagged [database-permissions]

238 questions
0
votes
2 answers

Using subquery in SSIS results in NULL values

I am trying to execute some SQL within a OLE DB Source Connector within SSIS that will get some statistics regarding databasesizes. This query ran fine when used in SSIS for one server. Now however I am looping through a number of servers and two…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
1 answer

The difference between MySQL wildcards for granting permissions

What is the difference between *, %, Any in the username/host fields when granting permissions to a user, and how would the combination of them differ? For example: GRANT ALL PRIVILEGES ON db.* TO '*'@'Any'; would this be the same as GRANT ALL…
xiankai
  • 2,773
  • 3
  • 25
  • 31
0
votes
1 answer

MySQL permissions and prepared statements

Im wondering if it's necessary to use different MySQL user permissions, if i use prepared statements and PDO? Basically i want a user with permission to SELECT and only SELECT, and a user who can use INSERT. I know prepared statements is a must, but…
DalekSall
  • 385
  • 1
  • 2
  • 12
0
votes
3 answers

How to stop mySQL users calling "show" functions

How can we prevent the the query "show databases;" or "show tables;" in mysql for any non root user.Is this possible.If so please provide an example or appropriate link...indicating this.. Thanks in advance........
Hulk
  • 32,860
  • 62
  • 144
  • 215
0
votes
1 answer

Read only SQL Server 2005 permission but allow stored procedure view

I have a SQL Server 2005 database and I need to be able to grant a user(someday a group) read only database permissions with the ability to view but not run or modify stored procedures across over a dozen databases. Is there a way to do this with…
user142253
  • 494
  • 1
  • 6
  • 16
0
votes
1 answer

Only allow update to another schema within a trigger

I'm using Oracle 11gR2, and I have two schemas -- A and B, and each has a similar CUSTOMER table. When B.CUSTOMER is updated, I want the same updates to happen to A.CUSTOMER. Schema A has full privileges to schema B, but I want schema B to have…
Mike
  • 1,039
  • 1
  • 12
  • 20
0
votes
0 answers

Why does the mysql % permission not work for all remotes on EC2?

I had a mysql admin issue with permissions on % hosts. EC2_DB launched with IP 10.55.142.100 and DNS ip-10-55-142-100.ec2.internal EC2_web launched with IP 10.55.142.144 and DNS ip-10-55-142-144.ec2.internal EC2_DB and EC2_WEB are in the same…
New Alexandria
  • 6,951
  • 4
  • 57
  • 77
0
votes
1 answer

bcp out to master..XP_cmdshell stored procedure not working when executed from excel

I have a stored procedure that uses bcp to create csv files executed in the cmdshell. When I run the stored procedure in sql server 2012 it executes like I need it to. But when I run it from excel VBA it only catches the first execution of the loop…
user2383360
  • 1
  • 1
0
votes
2 answers

C# and MySQL Connectors

Developing an application for a client that when users log off, it runs the program. The program so far grabs all the users internet browsing history and puts it to a html file, but they want to switch to a MySQL approach Got all the MySQL working,…
Richard Williams
  • 1
  • 1
0
votes
2 answers

App Pool User Unable to Execute Stored Procedure

Background I'm using SQL Server 2008 R2's full text search to retrieve a number of documents, and wish to use the results of sys.dm_fts_parser to highlight the matching terms. Doing that ordinarily requires permissions an app user should not have. …
Eric J.
  • 147,927
  • 63
  • 340
  • 553
0
votes
1 answer

SQL Server: Find out which users have write access to which tables?

In SQL Server 7.0, I need to find out which users have write access to which tables in a particular database. I know that I can do this in Enterprise Manager by going through each table in the database and looking at the access granted to those…
Peter Howe
  • 1,403
  • 2
  • 16
  • 30
0
votes
1 answer

CanCan best practice : automatically grant db-based permissions on creation

I use CanCan and a Permission model to manage permissions on a Folder model. When a user creates a folder, i want to create a permission to write for this user on the folder (i.e. create a permission record with field action set to 'write',…
m_x
  • 12,357
  • 7
  • 46
  • 60
0
votes
1 answer

Do I need to grant EXECUTE rights on a function that is called from a stored procedure?

I have a SQL function that is only called from inside another stored procedure. I have granted EXECUTE rights for the stored procedure that calls the function. Do I need to grant EXECUTE permissions to the function as well? EDIT In response to the…
Shai Cohen
  • 6,074
  • 4
  • 31
  • 54
0
votes
1 answer

How to add Active Directory user group as login in Tabular Model Database in SQL Server 2012

I need to give a 'Active Directory User Group' read access to a tabular model database. I am not able to find the group when searched, to add it to a role. As mentioned here for a database instance, adding the group to 'Logins' in 'Security' Folder…
monish001
  • 671
  • 2
  • 8
  • 20
0
votes
1 answer

User does not have permission to alter database

I am using MVC 4, Entity Framework 5, and the Code First approach. When I make changes to my model and run the application I get an error about not being able to drop the database because it is in use. To solve this, I've implemented my own…
PeteGO
  • 5,597
  • 3
  • 39
  • 70
1 2 3
…
15
16