Questions tagged [database-permissions]
238 questions
0
votes
1 answer
Inspect SQL permissions on built-in stored procedures (e.g. xp_msver)
I need to inspect the permissions in SQL on some built-in stored procedures. In Management Studio I see the permissions for custom SPs, but not the System SP. Additionally, there are a lot of SP's that aren't shown in the 'System Stored…
mechgt
- 41
- 1
- 9
0
votes
2 answers
Why do i need to have create database permissions for asp.net web app?
I am building an ASP.NET, code-first web app. I am using a company owned database, and have crud permissions for tables within one database on this server. I do not believe I have "Create Database" permissions. I am running into issues publishing my…
swallis1
- 99
- 1
- 13
0
votes
1 answer
How can give the menu permission to perticular user in Joomla?
I create some backend menu in joomla administrator like (Manager, admin, Super admin, agent).
First three are inbuilt and agent is custom. I want to give some particular menu permission to agent. so please tell me in database which tables having…
Dev D
- 1
- 4
0
votes
1 answer
Mysql cross table update permission problem
I'm doing a MySQL query similar to following:
UPDATE my_articles a
LEFT JOIN categorylinks cl ON a.pageid = cl.cl_from
SET a.importance = 'High'
WHERE cl.cl_to = 'High'
The problem is, I don't have a UPDATE right for the categorylinks…
svick
- 236,525
- 50
- 385
- 514
0
votes
1 answer
SQL Query Command not working but does not give error SQL Server
I am developing a database application in C#.NET and SQL Server 2012.
Some of my SQL statements are not working properly . When I execute the code it does not give any error. But when I try to delete something or Update a record, I does not do…
Muhammad Shahid
- 19
- 1
- 9
0
votes
1 answer
How to configure database permissions correctly in postgresql
What is the correct way to setup up a database in a new server? I'm currently using an EC2 instance with Ubuntu 14.04. This is what I have done so far:
First install postgresql
$ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/…
r_31415
- 8,752
- 17
- 74
- 121
0
votes
1 answer
SQL Server 2008 permission for View Dependencies
I would like to enable a SQL server user with read-only access to a DB the ability to view object dependencies. As a sysadmin I can select a table in SSMS and view any dependent objects (views, SPROCs, etc). My read-only users can see very few or…
Colin
- 846
- 7
- 16
0
votes
0 answers
MariaDB - MySQL GRANT permissions to table names not matching pattern
I'm using MariaDB. I have a set of entity tables like order, inventory etc and other audit tables order_audit, inventory_audit to track any changes made to the original tables. I do not want to allow database user that is being used by the Java…
TechCrunch
- 2,924
- 5
- 45
- 79
0
votes
1 answer
How do I grant limited access to sysprocesses in SQL Server 2005?
I'm implementing some rudimentary SQL Server monitoring to watch for excessive blocking.
I have a stored procedure that looks like this:
CREATE PROCEDURE [dbo].[bsp_GetBlockedProcessCount]
AS
BEGIN
SET NOCOUNT ON;
DECLARE @count INT
…
Robin Minto
- 15,027
- 4
- 37
- 40
0
votes
2 answers
How to give read and write permissions to a user to my database?
I am looking for a way to guarantee read and write permissions to my database to another user in my network.
I know Microsoft SQL Server Management lets my add users by right clicking on the user section
here
and filling this
form.
Still, I am not…
MaayanCh
- 1
0
votes
1 answer
Postgres: COPY TO error
I need help turning my Postgres table into a CSV file. First, I type
sudo su postgres (then I enter my password)
psql -d postgres -U postgres
The terminal looks like:
postgres=#
I typed in the COPY TO command to try to create a .csv file with all…
hsivru
- 55
- 1
- 8
0
votes
0 answers
Connecting play framework to mysql
I have two databases in mysql:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| app |
| app_dev …
Imran
- 413
- 3
- 13
0
votes
1 answer
Securing ASP.Net user database
I'm working on the web app which will be hosted on the client's server.
There are various restrictions/security measures in place and I'm concerned that these can be "hacked" because the client will have a direct access to the ASP.Net user database…
user338195
0
votes
1 answer
Created a user with permissions to one table, but unable to access the database that contains the table
I've tried to create a Login that will have access to a single table from a few different databases.
When I try and query the table, using the created Login I get the following error:
The server principal "log_Reader" is not able to access the…
Jason Campbell
- 146
- 1
- 10
0
votes
1 answer
SQL Server 2005 - Schema Ownership Stuck
I've created a database role in SS2005 and mistakenly made it the owner of the db_denydatareader schema. SSMS will not allow me to untick this option:
This post suggested that I change the ownership of that schema back to dbo (or whatever the…
kad81
- 10,712
- 3
- 38
- 44