grant drop view ...

[Skylined]

I need to 'GRANT DROP VIEW TO ...' but this is not possible. Is there any way I can give a login rights tp do this in an individual database?
I though of creating a db role specifically for this but can't figure how to give the role ability to 'DROP VIEW'.

Any help would be gladly appreciated

Regards,
Harry

 

[kim1]

Hi,

There is no such thing as GRAND DROP VIEW TO ...

If you GRANT permission to create a view, the user will have permission to drop the view.

Create a role
GRAND CREATE VIEW TO the role
Assign the user to that role.

Kim

 

[tlbroadbent]

DROP is part of the SQL Data Definition Langauge (DDL). You can assign a user to the database role of db_ddladmin but then that person could Create, Drop and Alter any objects. I don't know of any way to Grant Drop View permissions.

Books Online say,

"DROP VIEW permissions default to the view owner, and are not transferable. However, members of the db_owner and db_ddladmin fixed database role and sysadmin fixed server role can drop any object by explicitly specifying the owner in DROP VIEW." (emphasis added) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.