Re: What's the fastest way to assign read/write/execute right to a user?
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/25/02
- Next message: Sue Hoegemeier: "Re: How to change the owner of a table in SQL 65?"
- Previous message: Sue Hoegemeier: "Re: Client Enterprise manager security"
- In reply to: Bruce: "What's the fastest way to assign read/write/execute right to a user?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Tue, 24 Sep 2002 19:46:17 -0600
You can write a query to either generate a script of the
grant statements or use a cursor and loop through the
objects using dyanamic sql to grant the permissions.
There is no built in way to do this.
Some of the sites with scripts have examples along these
lines:
Swynk
http://www.swynk.com/sqlscripts/maintenance7.asp
SQL Server Central
http://www.sqlservercentral.com/scripts/
-Sue
On Tue, 24 Sep 2002 13:48:57 -0700, "Bruce"
<brucecheng@mail.com> wrote:
>But db_writer and db_reader don't have permission to run
>stored procedures nor user defined functions. I still need
>to manually assign every each stored procedures and
>functions.
>
>
>>-----Original Message-----
>>Look in SQL roles..
>>db_writer, db_reader
>>
>>Aleem A Mohammed
>>>-----Original Message-----
>>>What's the fastest way to set a user to have read/write
>>>rights to all tables/views and execute rights to all
>>>stored procedures/user defined functions? But I don't
>>want
>>>this user be able to change definitions of
>>>tables/views/stored procedures/user defined functions.
>>Nor
>>>create any new database objects.
>>>.
>>>
>>.
>>
- Next message: Sue Hoegemeier: "Re: How to change the owner of a table in SQL 65?"
- Previous message: Sue Hoegemeier: "Re: Client Enterprise manager security"
- In reply to: Bruce: "What's the fastest way to assign read/write/execute right to a user?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
