A set of permissions.

learn more… | top users | synonyms

0
votes
2answers
3k 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
1k 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 ...
3
votes
3answers
196 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
533 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 ...
3
votes
3answers
9k 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
3k views

What is the difference between ROLE and PRIVILEGE for Oracle?

Is role a collection of certain privileges?