Bulk GRANT statements

On occassion I have to set close to 100 seperate
permissions on various objects, and obviously that gets
tedious with enterprise manager.
In my Oracle days I would 1) create a SELECT statement
that prints out the GRANT statements 2) output the SELECT
to a file, and 3) execute the file in the Oracle
equivalent of Sql Query Analyzer.
I know how to create the GRANT statements (1), but I dont
know how to perform 2 and 3 (or whatever is the better
method) in SQL Server 2000.
Any help would be greatly appreciated.
MarkOnce you have granted the permissions using Enterprise
Manager, you can output them to a file using the script
utility in the tools menu. You can then open the script,
edit it, and execute it in Query Analyzer.
Bill
>--Original Message--
>On occassion I have to set close to 100 seperate
>permissions on various objects, and obviously that gets
>tedious with enterprise manager.
>In my Oracle days I would 1) create a SELECT statement
>that prints out the GRANT statements 2) output the
SELECT
>to a file, and 3) execute the file in the Oracle
>equivalent of Sql Query Analyzer.
>I know how to create the GRANT statements (1), but I
dont
>know how to perform 2 and 3 (or whatever is the better
>method) in SQL Server 2000.
>Any help would be greatly appreciated.
>Mark
>.
>

Building a new database on SQL Server 2000 cluster

The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition Clu
ster (2 boxes)
The I attach th the SQL Server Thru Enterprise Manager, right -click databas
es, and select new database...I can type the name of the new database, but w
hen I go to look for the other drives in the cluster I can only see the (Mas
ter) drive ...where SQL Ser
ver is installed. How can I view all of the current resources (drives) owne
d by that node in the cluster?
Thanks,
WarrenYou have to add them to the cluster ... This is in cluster administrator.
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:41DA8BCE-72D7-41AF-9A9A-5DD06DBCF760@.microsoft.com...

quote:

---

> The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition

---

Cluster (2 boxes)

quote:

---

> The I attach th the SQL Server Thru Enterprise Manager, right -click

---

databases, and select new database...I can type the name of the new
database, but when I go to look for the other drives in the cluster I can
only see the (Master) drive ...where SQL Server is installed. How can I
view all of the current resources (drives) owned by that node in the
cluster?

quote:

---

> Thanks,
> Warren

---

|||Thanks Wayne.
I can see all the drive within the cluster administrator. Is there another
step that i didn't do? The fail-over works perfectly and each node owns it'
s own resources. But I can view the different drives within Enterprise Manag
er...
Thanks,
Warren Tyler|||Correction on the above entry..
I can't view any of the drive from within Enterprise Manager

Building a new database on SQL Server 2000 cluster

The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition Cluster (2 boxes
The I attach th the SQL Server Thru Enterprise Manager, right -click databases, and select new database...I can type the name of the new database, but when I go to look for the other drives in the cluster I can only see the (Master) drive ...where SQL Server is installed. How can I view all of the current resources (drives) owned by that node in the cluster?
Thanks
WarrenYou have to add them to the cluster ... This is in cluster administrator.
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:41DA8BCE-72D7-41AF-9A9A-5DD06DBCF760@.microsoft.com...
> The environment: Windows Server 2003, SQL Server 2000 Enterprise Edition
Cluster (2 boxes)
> The I attach th the SQL Server Thru Enterprise Manager, right -click
databases, and select new database...I can type the name of the new
database, but when I go to look for the other drives in the cluster I can
only see the (Master) drive ...where SQL Server is installed. How can I
view all of the current resources (drives) owned by that node in the
cluster?
> Thanks,
> Warren|||Thanks Wayne
I can see all the drive within the cluster administrator. Is there another step that i didn't do? The fail-over works perfectly and each node owns it's own resources. But I can view the different drives within Enterprise Manager..
Thanks
Warren Tyler|||Correction on the above entry..
I can't view any of the drive from within Enterprise Manager