|
|
You're in the
sql server msde
group:More Questions on Permission
sql server msde:
Thanks Hari, That helps a lot.
Do I have a way to know previlage details about an Object? such as is the SELECT on a table been Granted, revoked or denied? Greg Chang Subject: Re: Questions about syspermissions From: "Hari" <hari_prasad_k@hotmail.com> Sent: 6/24/2004 9:29:17 PM HI, Have a look into sysprotects table, column action contains the granted previlages for each objects. The explanation for Action column:- 26 = REFERENCES 178 = CREATE FUNCTION 193 = SELECT 195 = INSERT 196 = DELETE 197 = UPDATE 198 = CREATE TABLE 203 = CREATE DATABASE 207 = CREATE VIEW 222 = CREATE PROCEDURE 224 = EXECUTE 228 = BACKUP DATABASE 233 = CREATE DEFAULT 235 = BACKUP LOG 236 = CREATE RULE Simply you can execute the below system procedure to get the objct level previlages:- sp_helprotect <object_name> -- Thanks Hari MCDBA [quoted text, click to view] "Greg Chang" <anonymous@discussions.microsoft.com> wrote in messagenews:210fa01c45a0e$23130eb0$a501280a@phx.gbl... [quoted text, click to view] > is syspermissions table contains the Permissions of > delete, select, insert, update, execute and DRI on all > the objects? > > how do I use this syspermissions table? For example, > which column stored the INSERT Privileges? > > thanks > > Greg Chang ..
See the BOL for information about the sp_helprotect stored procedure.
Jim [quoted text, click to view] "Greg Chang" <anonymous@discussions.microsoft.com> wrote in message news:21e9701c45d1b$c99a0170$a601280a@phx.gbl... > Thanks Hari, That helps a lot. > Do I have a way to know previlage details about an Object? > such as is the SELECT on a table been Granted, revoked or > denied? > > Greg Chang > > > > Subject: Re: Questions about syspermissions > From: "Hari" <hari_prasad_k@hotmail.com> Sent: > 6/24/2004 9:29:17 PM > > HI, > > Have a look into sysprotects table, column action > contains the granted > previlages for each objects. > > The explanation for Action column:- > 26 = REFERENCES > 178 = CREATE FUNCTION > 193 = SELECT > 195 = INSERT > 196 = DELETE > 197 = UPDATE > 198 = CREATE TABLE > 203 = CREATE DATABASE > 207 = CREATE VIEW > 222 = CREATE PROCEDURE > 224 = EXECUTE > 228 = BACKUP DATABASE > 233 = CREATE DEFAULT > 235 = BACKUP LOG > 236 = CREATE RULE > > > Simply you can execute the below system procedure to get > the objct level > previlages:- > > sp_helprotect <object_name> > > -- > Thanks > Hari > MCDBA > "Greg Chang" <anonymous@discussions.microsoft.com> wrote > in message > news:210fa01c45a0e$23130eb0$a501280a@phx.gbl... > > is syspermissions table contains the Permissions of > > delete, select, insert, update, execute and DRI on all > > the objects? > > > > how do I use this syspermissions table? For example, > > which column stored the INSERT Privileges? > > > > thanks > > > > Greg Chang > > > . > >
What is BOL?
[quoted text, click to view] >-----Original Message-----
>See the BOL for information about the sp_helprotect stored procedure. > >Jim > >"Greg Chang" <anonymous@discussions.microsoft.com> wrote in message >news:21e9701c45d1b$c99a0170$a601280a@phx.gbl... >> Thanks Hari, That helps a lot. >> Do I have a way to know previlage details about an Object? >> such as is the SELECT on a table been Granted, revoked or >> denied? >> >> Greg Chang >> >> >> >> Subject: Re: Questions about syspermissions >> From: "Hari" <hari_prasad_k@hotmail.com> Sent: >> 6/24/2004 9:29:17 PM >> >> HI, >> >> Have a look into sysprotects table, column action >> contains the granted >> previlages for each objects. >> >> The explanation for Action column:- >> 26 = REFERENCES >> 178 = CREATE FUNCTION >> 193 = SELECT >> 195 = INSERT >> 196 = DELETE >> 197 = UPDATE >> 198 = CREATE TABLE >> 203 = CREATE DATABASE >> 207 = CREATE VIEW >> 222 = CREATE PROCEDURE >> 224 = EXECUTE >> 228 = BACKUP DATABASE >> 233 = CREATE DEFAULT >> 235 = BACKUP LOG >> 236 = CREATE RULE >> >> >> Simply you can execute the below system procedure to get >> the objct level >> previlages:- >> >> sp_helprotect <object_name> >> >> -- >> Thanks >> Hari >> MCDBA >> "Greg Chang" <anonymous@discussions.microsoft.com> wrote >> in message >> news:210fa01c45a0e$23130eb0$a501280a@phx.gbl... >> > is syspermissions table contains the Permissions of >> > delete, select, insert, update, execute and DRI on all >> > the objects? >> > >> > how do I use this syspermissions table? For example, >> > which column stored the INSERT Privileges? >> > >> > thanks >> > >> > Greg Chang >> >> >> . >> >> > > >.
BOL = Books OnLine, which is the documentation for SQL Server. You can find
it in the SQL Server program group, and you can download the latest updated version from www.microsoft.com/sql -- Jacco Schalkwijk SQL Server MVP [quoted text, click to view] "Greg Chang" <anonymous@discussions.microsoft.com> wrote in message news:2239e01c45d22$4877f9b0$a301280a@phx.gbl... > What is BOL? > > >-----Original Message----- > >See the BOL for information about the sp_helprotect > stored procedure. > > > >Jim > > > >"Greg Chang" <anonymous@discussions.microsoft.com> wrote > in message > >news:21e9701c45d1b$c99a0170$a601280a@phx.gbl... > >> Thanks Hari, That helps a lot. > >> Do I have a way to know previlage details about an > Object? > >> such as is the SELECT on a table been Granted, revoked > or > >> denied? > >> > >> Greg Chang > >> > >> > >> > >> Subject: Re: Questions about syspermissions > >> From: "Hari" <hari_prasad_k@hotmail.com> Sent: > >> 6/24/2004 9:29:17 PM > >> > >> HI, > >> > >> Have a look into sysprotects table, column action > >> contains the granted > >> previlages for each objects. > >> > >> The explanation for Action column:- > >> 26 = REFERENCES > >> 178 = CREATE FUNCTION > >> 193 = SELECT > >> 195 = INSERT > >> 196 = DELETE > >> 197 = UPDATE > >> 198 = CREATE TABLE > >> 203 = CREATE DATABASE > >> 207 = CREATE VIEW > >> 222 = CREATE PROCEDURE > >> 224 = EXECUTE > >> 228 = BACKUP DATABASE > >> 233 = CREATE DEFAULT > >> 235 = BACKUP LOG > >> 236 = CREATE RULE > >> > >> > >> Simply you can execute the below system procedure to > get > >> the objct level > >> previlages:- > >> > >> sp_helprotect <object_name> > >> > >> -- > >> Thanks > >> Hari > >> MCDBA > >> "Greg Chang" <anonymous@discussions.microsoft.com> > wrote > >> in message > >> news:210fa01c45a0e$23130eb0$a501280a@phx.gbl... > >> > is syspermissions table contains the Permissions of > >> > delete, select, insert, update, execute and DRI on > all > >> > the objects? > >> > > >> > how do I use this syspermissions table? For example, > >> > which column stored the INSERT Privileges? > >> > > >> > thanks > >> > > >> > Greg Chang > >> > >> > >> . > >> > >> > > > > > >. > >
hi Greg,
"Greg Chang" <anonymous@discussions.microsoft.com> ha scritto nel messaggio news:2239e01c45d22$4877f9b0$a301280a@phx.gbl... [quoted text, click to view] > What is BOL? BOL stands for Books On Line, the official on-line guide for SQL Server, you can download, in localized version at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp it's the best documentation ever about SQL Server... -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |