Questions tagged [database-permissions]
238 questions
0
votes
1 answer
sqlite3 on iPhone emulator versus device permissions?
Ok, now I finished developing on the emulator and when I installed on my test device, I got the error
attempt to write a readonly database
What are the settings to control the DB access? Is this going to be difficult to manage when deployed?
More…

mobibob
- 8,670
- 20
- 82
- 131
0
votes
0 answers
Fetch column names of particular table having specific permission
Need to fetch all column names of particular table having specific permission.
I am trying this:
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'persons'
I want column names having viewer permissions in person table. Above…

Shrenik
- 33
- 8
0
votes
1 answer
Sql Server grant permission for sp_grantdbaccess on a newly restored DB
I am unable to grant access to a newly restored database using sp_grantdbaccess. I am trying to do this via dynamic sql like below.
DECLARE @grant_access nvarchar(500)
SET @grant_access = 'EXEC ' + @new_db_name + '.dbo.sp_grantdbaccess ''IIS…

flerngobot
- 616
- 1
- 9
- 30
0
votes
2 answers
How to assign permissions for a database or a column in SQL Server?
I am not really a database guy. I had to use a localdb for an application that I created using ASP.NET MVC 5. Now, I understand that the type of database can easily be changed by altering the connection string.
What I want to do is for me to be able…

ritratt
- 1,703
- 4
- 25
- 45
0
votes
2 answers
Would this hack for per-object permissions in django work?
According to the documentation, a class can have the meta option permissions, described as such:
Options.permissions
Extra permissions to enter into the permissions table when creating this object. Add, delete and change permissions are…

Edward
- 21
- 1
0
votes
0 answers
Use Windows Auth in ASP.NET to access sql server
is there a way to use windows accounts, that are logged into an web application, to use their credentials to access SqlServer, and use entity framework database first to execute various queries under their credentials?

Aflred
- 4,435
- 6
- 30
- 43
0
votes
0 answers
Role structure to manage permissions for groups of users and databases in SQL Server
Some background which might help; for each new system we are developing, we have three groups of databases:
dbgDev [Sys1_dev, Sys2_dev, Sys3_dev]
dbgTest [Sys1_test, Sys2_test, Sys3_test]
dbgProd [Sys1_prod, Sys2_prod, Sys3_prod]
and different…

MoonBrain
- 11
- 5
0
votes
1 answer
check permissions in a database
we are using SQL2012 Enterprise Edition and have a small problem with one of our DBA (5 persons with more than 100 instances). is it possible to check who has changed given, denied or revoked permissions and when this was done? I could not find any…
0
votes
1 answer
How to design Menubar as per permissions
I have a application and in that, I have permission form. I am assigning permission as per jsp forms to user.If any user has permission to access the form, that form will be added to menu bar after login. I dont know how to do it. Can someone…

Aditya Ekbote
- 1,493
- 3
- 15
- 29
0
votes
1 answer
Mysql.User doesn't show all of the privileges
A colleague of mine had recently created a couple of mysql (v 5.6.x) users (test purposes only).
When I checked the mysql.user table, this is what I see:
mysql> select * from…

TJ-
- 14,085
- 12
- 59
- 90
0
votes
2 answers
Restrict stored procedure to only perform SELECT operations
Is is possible to restrict a stored proc to only SELECT from a database.
I want a stored proc which only selects data to execute correctly and a stored proc with UPDATE, CREATE, DELETE operations to return an error indicating insufficient…

vaughan
- 6,982
- 6
- 47
- 63
0
votes
0 answers
Invalid object name 'Student' while running IIS webservice using SQL Server 2005 database
I created a web-service using asp.NET and the database is created using SQL Server 2005. Then I published it to be able to use it from an Android device. I used the IIS Manager to publish it as local IIS. the publishing is done well but when I try…

user3287580
- 93
- 1
- 9
0
votes
0 answers
Permissions for underlying tables while using internal SQL Server authentication
Normally I used Windows authentication with MSSQL server. There were schemas in databases which correspond to specific Windows logins. These schemas I used for stored procedures, but underlying tables were dbo with default permissions.
Now I try to…

Paul
- 25,812
- 38
- 124
- 247
0
votes
3 answers
Database access permissions issue (sql server 2008)
I have created a C# app that reads a config file, gets connection strings, and for each connection string it reads list of stored proc for some further processing.
Now, I'm facing some permissions issues. When developing the app I was using…

Andrey
- 20,487
- 26
- 108
- 176
0
votes
1 answer
SELECT OBJECT_DEFINITION(object_id) FROM sys.objects returns NULL for Tables only
Using the following sp I plan to export my object definitions to text files, and then import them into SVN. The sp works fine for stored procedures and views. However, when used for user tables it returns me a correctly named file for each table,…

Hecatonchires
- 1,009
- 4
- 13
- 42