Stack Overflow
Stack Overflow

Questions tagged [database-permissions]

238 questions
2
votes
1 answer

Is there a recommended practice or framework to achieve record-level-permission for google-app-engine db.Model/ ndb.Model)?

Is there a recommended practice or framework to achieve record-level-permission and attribute level visibility with google-app-engine db.Model (and/or ndb.Model) ? I have read about model-hooks, but I would love to see if there is an existing…
anups
  • 583
  • 1
  • 7
  • 18
2
votes
1 answer

Specifying granted permissions to SQL CLR User Defined Functions for deployment

I have created a user defined function in .NET 2.0 and am able to successfully deploy it to my local SQL Server instance. However, I need to grant a specific user EXECUTE permission on the function. I want this to be done in the CLR method itself…
Andy
  • 338
  • 3
  • 8
2
votes
1 answer

Error accessing stored procedure

We have a .NET3.5 Windows Forms application that calls an ASP.NET SOAP web service on the same server. This web service then saves the data into a SQL Server Express 2005 database, again on the same server. The application has been deployed…
Jon Lawson
  • 582
  • 1
  • 6
  • 16
2
votes
1 answer

Restricting a user to access only his own tables in Oracle SQL Developer

I am confused in the permission, privileges in the SQL Oracle Developer. The user created can access all the schema/user 's tables. I want to restrict specific user in the database to access (ALTER, DROP, UPDATE etc) to his own tables only. Can any…
AbdulAziz
  • 5,868
  • 14
  • 56
  • 77
2
votes
2 answers

SQL Server 2008 Management studio - can't see tables, can run queries

Well, I have a database running on shared hosting and have successfully connected to it. However, i cannot see the database but when i run i.e. SELECT * FROM Item Item is a table in it, i get correct result. Further more, when connected via Visual…
Bip
  • 893
  • 5
  • 14
  • 29
1
vote
1 answer

Creating database role in sql server that can be mapped to multiple logins

Scenario.. 1 database role - 5 developers needs to be mapped with same access. All 5 developers must login to sql server using there own username and password. I want all these 5 developers must be mapped to 1 unique database role. So that if I…
Shantanu Gupta
  • 20,688
  • 54
  • 182
  • 286
1
vote
2 answers

what is the minimum access level on a sql server the asp.net membership need?

for security reason, what is the minimum access level the asp.net membership user could have?
Fredou
  • 19,848
  • 10
  • 58
  • 113
1
vote
3 answers

SQL Permissions to Add data and how to verify?

I'm looking for a good way to maintain permissions on who can add data to a database in a C# app and SQL Server 2005. I need to explain though to make this clear. So let's take an example of this: I have two users Bob and Jim, both have been added…
Coding Monkey
  • 990
  • 10
  • 17
1
vote
2 answers

SQL Server 2005 user-defined data type, tempdb and permissions

I have a DB running on SQL Server 2005 that has a user-defined data type. The user-defined data type is also implemented in the model database, so that when I create a temp table I can use the same user-defined data type. For instance, in AppDB I…
Geoffrey McGrath
  • 1,663
  • 1
  • 14
  • 35
1
vote
2 answers

What permissions to 'real' databases grant users?

In reading @PerformanceDBA's answer to Historical / auditable database he made this statement: In a real (standard ISO/IEC/ANSI SQL) database, we do not GRANT INSERT/UPDATE/DELETE permission to users. We GRANT SELECT and REFERENCES only (to…
Paul
  • 6,188
  • 1
  • 41
  • 63
1
vote
1 answer

DotNetNuke initial installation security best practice

I've installed several DotNetNuke sites on Windows Server 2008. What I'd like to know is how the various security entities should be configured together. For example, some installation references recommend setting the site file's permission to…
soulia
  • 483
  • 2
  • 6
  • 20
1
vote
2 answers

Retrieve all tables selectable by a user (in Oracle)

How can I retrieve a list of all tables to which a user is has SELECT permission (either granted directly or through an assigned role)?
ivan
  • 390
  • 3
  • 13
1
vote
1 answer

SQL Server 2008 Multi-database Permissions via role or schema or scripting

Let's say that there are multiple users in my office that need access to multiple databases that are dependent upon each other. I have users who are sysadmins but as more employees are added I want to be able to apply specific permissions for these…
CBRRacer
  • 4,649
  • 1
  • 23
  • 27
1
vote
1 answer

PostgreSQL user groups and authorization

Postgresql version 9.0 I need an idea for grouping postgresql users. i have 150+ table in database, and i want to settle groups of people. some of them can reach all tables, some of them not. I know it is possible to make it using grant or creating…
sftsz
  • 346
  • 4
  • 14
1
vote
1 answer

PostgreSQL: How to view current "grant usage on schema" permissions?

Is there a system view in Postgres where I can see which users/roles have "grant usage" and on which schema?
XerX
  • 51
  • 6
1 2 3
…
15 16