What's the fastest way to assign read/write/execute right to a user?
From: Aleem A Mohammed (aleem.mohammed@datastructures.com)
Date: 09/24/02
- Next message: Aleem A Mohammed: "!!! How to find installed Hotfixes on SQL servers"
- Previous message: Leon Parker: "Reading SysProcess System Table to find idle processes"
- In reply to: Bruce: "What's the fastest way to assign read/write/execute right to a user?"
- Next in thread: Bruce: "What's the fastest way to assign read/write/execute right to a user?"
- Reply: Bruce: "What's the fastest way to assign read/write/execute right to a user?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Aleem A Mohammed" <aleem.mohammed@datastructures.com> Date: Tue, 24 Sep 2002 13:31:48 -0700
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: Aleem A Mohammed: "!!! How to find installed Hotfixes on SQL servers"
- Previous message: Leon Parker: "Reading SysProcess System Table to find idle processes"
- In reply to: Bruce: "What's the fastest way to assign read/write/execute right to a user?"
- Next in thread: Bruce: "What's the fastest way to assign read/write/execute right to a user?"
- Reply: Bruce: "What's the fastest way to assign read/write/execute right to a user?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
