A set of permissions.
3
votes
2answers
47 views
Create database role to allow read access to all tables; write access to some
We have a database with over 1000 tables. I need to create a role that allows read only on all tables, as well as write access to two specific tables.
I was messing around with database roles, but ...
1
vote
1answer
69 views
Limiting user access to tables based on a ROLE
I have a SQL Server 2005 database to which I would like to LIMIT access. I have done the following:
Created a database role called NO_HR
Added the tables to this role under Securables that should be ...
1
vote
1answer
33 views
How to get user-specific settings in PostgreSQL?
I have to collect some information of PostgreSQL roles. One piece of information is whether the role has different settings than 'usual', usual meaning here default values for only a few parameters ...
0
votes
1answer
30 views
Add user to sql server with the required permission
In my sql server express 2008 r2 i have about 15 login account. Now i want some about 5 users have full permission while some other 5 users with limited access to some database, and other users only ...
2
votes
1answer
67 views
Do roles have an owner in oracle?
Suppose that i have logged in to oracle database using user X. then user X creates some roles using create role command. I want to know that is user X the owner of the roles? and can i select all ...
1
vote
1answer
266 views
Difference between Owned Schemas and Role Membership for Microsoft SQL Server
Are there differences between Owned Schemas and Role Members?
From my understanding, the Role Members are compulsory - user need to have at least one of the check box under Role Members checked.
...
2
votes
1answer
94 views
Oracle Packages, Procedures and Functions Not Respecting Roles
When you create a package, sproc or function in one schema (say, SCHEMA1) that accesses objects in another schema (SCHEMA2), even when SCHEMA1 has appropriate permissions to the respective SCHEMA2 ...
4
votes
1answer
3k views
PostgreSQL: permission denied for relation
I'm a bit confused about setting permissions in PostgreSQL.
I have these roles:
List of roles
Role name | Attributes | Member of
...
1
vote
1answer
601 views
Is there a backup operator role in Microsoft SQL Server 2008?
I have a Windows Server 2008 with Microsoft SQL Server 2008 and VERITAS NetBackup installed. Basically, this NetBackup requires a valid logon ID into the SQL Server that is powerful enough to do a ...
2
votes
3answers
89 views
What tasks can only sysadmin's do in SQL Server 2000?
I'm cleaning up permissions on my SQL Server 2000, and I want to verify that a particular account still has sysadmin privileges.
What non-destructive tasks can only sysadmins do that I can use to ...
5
votes
1answer
166 views
Map Oracle roles to Active Directory groups?
Is there any built-in way to map Oracle database roles to Microsoft Active Directory groups?
2
votes
2answers
719 views
Problem with permissions for user
Hi I'm trying to create a login role (user) with a fairly minimal ability to modify the database. They should be able to select, delete, create triggers, insert and update. I would then like to have ...
5
votes
2answers
99 views
Will a SP which writes records fail if accessed by a db_datareader role?
I have a stored procedure which is accessed remotely by an app which is running on some kind of Java/WebSphere type platform. It takes one argument, returns some data and that's that.
Recently there ...
0
votes
1answer
919 views
postgresql: how do I dump and restore roles for a cluster?
Where are roles stored in a cluster, and how do I dump them?
I did a pg_dump of a db and then loaded it into a different cluster, but I get a lot of these errors:
psql:mydump.sql:3621: ERROR: role ...
1
vote
2answers
1k views
How to deny drop permission for a table?
Is there a way to deny drop permissions for a specific table from a user or role?
8
votes
2answers
22k views
oracle - list users with access to certain tables
I'm sure this has been asked before but I can't seem to find the relevant details for the following.
Is there some sort of pre-built table that can do the following (I have used dba_tab_privs but it ...
2
votes
3answers
1k views
Oracle “Import from Export Files” screen refusing both SYSADMIN and Normal users
I have just installed Oracle 11g on Win64, and I want to import some .dmp files.
I am trying with the tool Oracle Enterprise Manager 11g:
If I log in with SYS as SYSADMIN, and go to Import from ...
3
votes
2answers
128 views
SQL 2005 Permission Precedence
Very simple question -
I have two database roles (Basic, Admin). Say I explicitly deny the Basic role from deleting from table A and grant that to the Admin role. If I am a user who is in both ...
0
votes
2answers
2k views
why user with db_owner & db_BackupOperator database role is unable to restore database?
I'm in sysadmin server role on the server .
All Programmers are in dbCreator Server role , So they can create databases for themselves and they have in db_owner & db_Backupoperator database role ...
1
vote
1answer
748 views
SQL Server 2005 Easy way to add all users to a database role
I have three application databases: A, B and C. Users of A and B are all users in C; the users from A are in the public role with only SELECT permission, while the users from B are in a role with more ...
2
votes
1answer
107 views
Are there any tables that I can get all Oracle supported system privileges and object privileges?
Are there any tables that I can get all Oracle supported system privileges and object privileges? I know there is a view called all_sys_privs in Oracle. But I can't find more information about it.
...
20
votes
1answer
427 views
Reporting Service and Application Role
First poster, long time lurker here.
What is the best way to activate application role in a report ?
I've tried different things and so far the only method that works is to embed the call to the ...
1
vote
3answers
4k views
When creating views, why do users need direct object permissions if they already have the same permissions via a role?
I'm having a problem with permissions in Oracle 10g. I'm hoping someone can help me make sense of this.
I have a schema with a table in it. I have granted select on that table to a role.
grant ...
3
votes
2answers
2k views
What is the difference between ROLE and PRIVILEGE for Oracle?
Is role a collection of certain privileges?
