What's the fastest way to assign read/write/execute right to a user?
From: Bruce (brucecheng@mail.com)
Date: 09/24/02
- Next message: Alli: "Client Enterprise manager security"
- Previous message: Aleem A Mohammed: "How to execute script.sql from VB6"
- In reply to: Aleem A Mohammed: "What's the fastest way to assign read/write/execute right to a user?"
- Next in thread: Sue Hoegemeier: "Re: What's the fastest way to assign read/write/execute right to a user?"
- Reply: Sue Hoegemeier: "Re: What's the fastest way to assign read/write/execute right to a user?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Bruce" <brucecheng@mail.com> Date: Tue, 24 Sep 2002 13:48:57 -0700
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: Alli: "Client Enterprise manager security"
- Previous message: Aleem A Mohammed: "How to execute script.sql from VB6"
- In reply to: Aleem A Mohammed: "What's the fastest way to assign read/write/execute right to a user?"
- Next in thread: Sue Hoegemeier: "Re: What's the fastest way to assign read/write/execute right to a user?"
- Reply: Sue Hoegemeier: "Re: What's the fastest way to assign read/write/execute right to a user?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|