Hello,
I am trying to write a script using SQL Server 2000 to list all of the
roles that have any permissions on a specified object (view, table,
sp, etc.). Essentially I am trying to script what is displayed when
one selects the 'list only users/user-defined database roles/public
with permissions to this object' option under 'manage permissions' in
EM but without showing individual users, only roles. I've looked at
the system sp's and the information_schema views but none of those
seem to give this information. Am I going to have to look directly at
the system tables? If anyone has a script that does this for a
specified object or can point me to more specific information on how
to do this I'd appreciate it. Thanks!
Bruce
2  8664 
Have you checked "sp_helprotect" , this one is permissions for all objects,
--
Jack Vamvas
___________________________________
The latest IT jobs - www.ITjobfeed.com
<a href="http://www.itjobfeed.com">UK IT Jobs</a>
"Bruce" <de***************@gmail.comwrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...
Hello,
I am trying to write a script using SQL Server 2000 to list all of the
roles that have any permissions on a specified object (view, table,
sp, etc.). Essentially I am trying to script what is displayed when
one selects the 'list only users/user-defined database roles/public
with permissions to this object' option under 'manage permissions' in
EM but without showing individual users, only roles. I've looked at
the system sp's and the information_schema views but none of those
seem to give this information. Am I going to have to look directly at
the system tables? If anyone has a script that does this for a
specified object or can point me to more specific information on how
to do this I'd appreciate it. Thanks!
Bruce
On Mar 14, 4:41 am, "Jack Vamvas" <DEL_TO_RE...@del.comwrote:
Have you checked "sp_helprotect" , this one is permissions for all objects,
--
Jack Vamvas
___________________________________
The latest IT jobs -www.ITjobfeed.com
<a href="http://www.itjobfeed.com">UK IT Jobs</a>
"Bruce" <deluxeinformat...@gmail.comwrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...
Hello,
I am trying to write a script using SQL Server 2000 to list all of the
roles that have any permissions on a specified object (view, table,
sp, etc.). Essentially I am trying to script what is displayed when
one selects the 'list only users/user-defined database roles/public
with permissions to this object' option under 'manage permissions' in
EM but without showing individual users, only roles. I've looked at
the system sp's and the information_schema views but none of those
seem to give this information. Am I going to have to look directly at
the system tables? If anyone has a script that does this for a
specified object or can point me to more specific information on how
to do this I'd appreciate it. Thanks!
Bruce
Thank you. I don't know how I overlooked that one. Sometimes I wish
BOL was laid out a little differently.
Bruce This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Prashant Thakwani |
last post by:
Can anybody tell, how to implement the application roles in SQL Server
2000.
Basically, I want to Implement the application roles in our
application, so that it can be application specific. Its'...
|
by: Matt Norwood |
last post by:
I am in need of a utility (stored procedure, third party app, etc)
that will help streamline the process of managing and auditing object
permissions, users and roles on multiple sql server 2000...
|
by: Matt Norwood |
last post by:
I am in need of a utility that will help streamline the process of
managing and auditing object permissions, users and roles on multiple
sql server 2000 instances with multiple databases on each...
|
by: Jason_Schaitel |
last post by:
I have an application that segregates data into two different
databases. Database A has stored procs that perform joins between
tables in database A and database B. I am thinking that I have...
|
by: bill |
last post by:
I am looking for examples and assistance in configuring application roles
using SQL Server 2000 and VB.NET, both web forms and windows forms.
Are there any suggestions?
Thanks
Bill
|
by: Mike Hofer |
last post by:
BACKGROUND: We've designed a Website for a client that will be
deployed across multiple physical locations. The site will be hosted
from a corporate NOC, and administered by the IT group there.
...
|
by: keithb |
last post by:
I developed a web site that uses sql server express for permissions and
roles. Now I need to deploy it on a server that uses sql server 2005
standard edition instead of sql server express. What do...
|
by: Andy |
last post by:
Hi,
I currently have my application setup and built using Windows
Authentication (WindowsPrincipal). For security checks, I simply do
an IsInRole call on the Principal. The role permissions...
|
by: aguy1306 |
last post by:
I have a large DB product running under MS SQL 2005 on windows server 2003 SP2.
I have problems with the uninformed changing permission on objects.
I need to build a SP that correctly sets the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
