Re: Query that involves publci role

From: oj (nospam_ojngo@home.com)
Date: 06/05/02 

From: "oj" <nospam_ojngo@home.com>
Date: Tue, 4 Jun 2002 23:01:02 -0700

here are some tips to get you started...
1. dump the result of exec sp_helprotect null,'public' into a tmp table
2. create 'deny' statements based on what is granted to public by querying
the tmp
3. exec #2 result 

--
-oj
Rac v2.1 coming soon
http://www.rac4sql.net
"FR" <floydrev@hotmail.com> wrote in message
news:u5p2HjEDCHA.1432@tkmsftngp04...
> Id like to know all the permissions granted to the public role for all
> objects in a certain database and based on that create another role to
deny
> the same for those  objects
>
> Can someone help me with the query ?
>
> Thanks
>
>

Relevant Pages

  • Re: Convert to Varbinary
    ... insert #tmp values ... create proc usp ... I tried the exec as you suggested -> even increased the varbinary to 256 - but the stored> procedure still does not convert the field in binary. ... This>>>works fine in SQL Query Analyzer. ...
    (microsoft.public.sqlserver.programming)
  • Re: Security Question. - FEXED, the Security NG helped.
    ... This acount that I am using is NOT a member of any supernumery group, ... just a plain jane user account. ... Everyone Read & Exec, List, Read ((Deny Write), ...
    (microsoft.public.windowsxp.general)
  • Re: Capture Stored PROC Output
    ... INTO #tmp EXEC sp ... EXEC sp_serveroption 'Server', 'Data Access', TRUE ... If you have #temp tables used in your stored procedure, ... Is there anyway to get the output of a stored procedure in a temp ...
    (microsoft.public.sqlserver.programming)
  • Re: SP Question: Can I pass an input parameter for table name?
    ... exec (@tmp) ... use the whole SQL query as a variable instead of TableName alone ...
    (microsoft.public.sqlserver.programming)
  • Re: temp table names
    ... create proc usp1 ... exec usp2 ... create proc usp2 ... select * from #tmp ...
    (microsoft.public.sqlserver.programming)