Re: More Questions on Permission

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 16:25:23 +0100

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
"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
> >>
> >>
> >> .
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: Wartungsplan schlägt teilweise fehl
    ... aus BOL SIMPLE is the default setting for SQL Server Personal Edition ... Die master-DB hat immer simple. ... Sicherung der Datenbank und alle Sicherungen der Tranaktionslogs. ... Lesestoff dazu im "SQL Server 2000 Operations Guide": ...
    (microsoft.public.de.sqlserver)
  • Re: Indexed Views
    ... >> wrong or the functionality was added with the SP's) ... The BOL information was wrong in the RTM version. ... SQL Server Documentation Team ... > "Tom Moreau" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Indexed Views
    ... There's an updated BOL beyond SP3a: ... "Tom Moreau" wrote in message ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Indexed View on Standard Ed
    ... This is one of the text that has changed in one of the BOL updates... ... "John Bell" wrote in message ... >>> Note Indexed views can be created in any edition of SQL Server 2000. ... >>>> created some on a Standard Ed box. ...
    (microsoft.public.sqlserver.server)
  • Re: Windows Authentication
    ... SQL Server MVP ... Columnist, SQL Server Professional ... www.pinnaclepublishing.com/sql "Greg Chang" wrote in message ... I am wondering how to create a VB aplication to login in by Windows authentication throught ADO, does anyone has an idea how to do it? ...
    (microsoft.public.sqlserver.programming)