Click here to Skip to main content
15,885,030 members
Home / Discussions / Database
   

Database

 
GeneralRe: Sql help Pin
pankajdaga11-Nov-03 20:35
pankajdaga11-Nov-03 20:35 
GeneralRe: Sql help Pin
jeff_martin12-Nov-03 7:44
jeff_martin12-Nov-03 7:44 
GeneralRe: Sql help Pin
pankajdaga12-Nov-03 21:42
pankajdaga12-Nov-03 21:42 
GeneralRe: Sql help Pin
jeff_martin13-Nov-03 3:36
jeff_martin13-Nov-03 3:36 
GeneralRe: Sql help Pin
pankajdaga13-Nov-03 10:15
pankajdaga13-Nov-03 10:15 
Generalaccess permissions Pin
ranjjj11-Nov-03 3:57
ranjjj11-Nov-03 3:57 
GeneralRe: access permissions Pin
ranjjj11-Nov-03 4:04
ranjjj11-Nov-03 4:04 
GeneralRe: access permissions Pin
Jeff Varszegi11-Nov-03 4:41
professionalJeff Varszegi11-Nov-03 4:41 
Ranjani,

You post messages pretty often. Why don't you sign up as a user? Just wondering.

Basically, the way SQL Server permissions go, you have permissions as the result of being a member of a Windows group or role, right? (When I speak of permissions, I also mean that you can be denied access to something.) Then on top of these group-related permissions, you can be explicitly granted or denied extra permissions. These are usually granted/denied/revoked using the GRANT, REVOKE, and DENY statements in Transact-SQL, since most admin types use Transact-SQL to script this stuff up.

The ListUserPermissions method lists the permissions of the second type: special added-on permissions granted specially for a specific user. It won't include permissions that a user has through inclusion in a role, for instance, so be careful.

Also, you should realize that the Permission object can represent the fact that a user is denied access to something-- check out the Granted property.

Hope this helps.

Regards,

Jeff Varszegi
Generalextended procedure for sql server Pin
mhmoud rawas11-Nov-03 1:21
mhmoud rawas11-Nov-03 1:21 
GeneralRe: extended procedure for sql server Pin
Mike Dimmick11-Nov-03 10:08
Mike Dimmick11-Nov-03 10:08 
GeneralRe: extended procedure for sql server Pin
mhmoud rawas11-Nov-03 18:21
mhmoud rawas11-Nov-03 18:21 
GeneralRe: extended procedure for sql server Pin
Mike Dimmick11-Nov-03 23:02
Mike Dimmick11-Nov-03 23:02 
GeneralRe: extended procedure for sql server Pin
mhmoud rawas11-Nov-03 23:16
mhmoud rawas11-Nov-03 23:16 
GeneralMore DTS questions Pin
Megan Forbes10-Nov-03 23:49
Megan Forbes10-Nov-03 23:49 
QuestionDataGrid - stopping additions, while allowing edits: possible? Pin
Pauwll10-Nov-03 23:46
Pauwll10-Nov-03 23:46 
AnswerRe: DataGrid - stopping additions, while allowing edits: possible? Pin
Mike Dimmick11-Nov-03 10:13
Mike Dimmick11-Nov-03 10:13 
GeneralRe: DataGrid - stopping additions, while allowing edits: possible? Pin
Pauwll11-Nov-03 17:56
Pauwll11-Nov-03 17:56 
GeneralMigrate SQL to Oracle Pin
TPN10-Nov-03 16:40
TPN10-Nov-03 16:40 
GeneralRe: Migrate SQL to Oracle Pin
Guillermo Rivero12-Nov-03 7:31
Guillermo Rivero12-Nov-03 7:31 
GeneralRe: Migrate SQL to Oracle Pin
Mike Dimmick13-Nov-03 2:54
Mike Dimmick13-Nov-03 2:54 
GeneralIn-Memory Databases Pin
Andrew Shapira10-Nov-03 12:16
Andrew Shapira10-Nov-03 12:16 
GeneralRe: In-Memory Databases Pin
Arjan Einbu10-Nov-03 22:45
Arjan Einbu10-Nov-03 22:45 
GeneralStopping SQL Pin
Megan Forbes10-Nov-03 3:12
Megan Forbes10-Nov-03 3:12 
GeneralRe: Stopping SQL Pin
Jeff Varszegi10-Nov-03 3:36
professionalJeff Varszegi10-Nov-03 3:36 
GeneralRe: Stopping SQL Pin
Megan Forbes10-Nov-03 3:47
Megan Forbes10-Nov-03 3:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.