Re: db role to create/drop tables, views, usps
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/28/02
- Next message: Ida: "use of host_name( ) in triggers"
- Previous message: TO: "db role to create/drop tables, views, usps"
- In reply to: TO: "db role to create/drop tables, views, usps"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Tue, 28 May 2002 15:27:19 -0600
Take a look at the db_ddladmin fixed database role.
-Sue
On Tue, 28 May 2002 14:15:44 -0700, "TO" <cto@aifs.com>
wrote:
>What would be the least possible rights granted to the
>users who need to create/drop tables, views, or stored
>procedures in a particular database?
>
>I am reluctunt to grant dbo to the user.
- Next message: Ida: "use of host_name( ) in triggers"
- Previous message: TO: "db role to create/drop tables, views, usps"
- In reply to: TO: "db role to create/drop tables, views, usps"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]