Solved

syspermissions.id is negative

Posted on 2010-09-02
2
254 Views
Last Modified: 2012-05-10
when the value for syspermissions.id is something like -489, how do you interpret it, there are also other values like 0 and positive integers.

thanks
0
Comment
Question by:anushahanna
2 Comments
 
LVL 41

Accepted Solution

by:
ralmada earned 500 total points
ID: 33589963
Per BOL
>>The id column references the object ID for which the permissions are being granted or denied. For statement permissions, this column is set to zero.<<
Bottom line is just an object_ID.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33590099
Thanks ralmada-your answer gave me a clue
select object_name(id) from syspermissions where id<0
they are all system stuff...

0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now