WITH GRANT OPTION - Microsoft SQL Server

Kamal

I need to check if any user in the database is assigned any permission
WITH GRANT OPTION. Please let me know how do I check this. Also let me
know if assigning rights WITH GRANT OPTION is possible from enterprise
manager.

Thanks in advance
Kamal

Jul 20 '05 #1

Subscribe Post Reply

4084

Simon Hayes

"Kamal" <ka****@melstar.com> wrote in message
news:a4**************************@posting.google.c om...

I need to check if any user in the database is assigned any permission
WITH GRANT OPTION. Please let me know how do I check this. Also let me
know if assigning rights WITH GRANT OPTION is possible from enterprise
manager.

Thanks in advance
Kamal

See "sysprotects" in Books Online:

select
object_name(id),
user_name(uid),
user_name(grantor) as 'Granted by'
from
sysprotects
where
protecttype = 204

I don't know about granting that from EM, but since Query Analyzer gives you
better control over TSQL commands, it would probably be better to create a
permissions script which you can then run in many databases.

Simon

Jul 20 '05 #2

Similar topics

Dynamic SELECT boxes with <OPTGROUP>s

by: cedawe | last post by:

I have two select boxes. When the user picks a value in the first one it completely re-populates the second one. It works fine, but only generates a standard OPTIONS list and I now want to group...

Javascript

The bug in IE with image maps and the statas bar continues with <OPTION>

by: George Hester | last post by:

Try it. Using Microsoft Internet Explorer 5.5 SP2 (that's the version I am using) in Windows 2000 SP3: In a html put this in: <select type="select-one" id="oSel1"> <option value="1"...

Javascript

href with onClick javascript problem in new window

by: Mike | last post by:

In my previous post, I wrote: > ... > GOAL: (very simple) Provide a hyperlink which, when clicked, > calls a javascript function which opens a new URL. > ... > PROBLEM: The following code...

Javascript

Basic .NET strategy

by: Grant Schenck | last post by:

Hello, I'm pretty new to C# and .NET. I've been tasked with creating an Internet Explorer toolbar. I implemented it and it works OK, however, because the toolbar has a notion of having to...

C# / C Sharp

Problem with html list box control

by: http://www.visual-basic-data-mining.net/forum | last post by:

I have the following problem. My asp.net page has one html list box control and I made that as "RUN AS SERVER" so that I could access it in client side script as well as server side script. And also...

ASP.NET

Security Permission Issue with C# EXE on Intranet

by: Johann Pietschnig | last post by:

Hi, My Problem: I have a C# EXE which writes a TXT file with results. It works perfect on my local computer, but when I try to run it from our network server (Drive G:), I am getting a...

C# / C Sharp

how to grant all tables

by: john_woo | last post by:

Hi, db2 GRANT all on a_table_name to user me is for a table, I'm wondering possible to grant all on all_tables to user me, without listing all tables' names? -- Thanks John

DB2 Database

Create Database with RESTRICTIVE Option

by: Mark A | last post by:

At first glance it seems like a good idea to use the new RESTRICTIVE option when creating a database to remove public access otherwise granted by default. Then one could grant the required access...

DB2 Database

Issues with 'Select' function - Trying to call up data into a query

by: SteveGod | last post by:

Hi, I'm trying to create a report that will produce automated sets of Committee Minutes for School Appeals, where there are a set range of different outcomes. The field involved are all from...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

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

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++