Very Computer

Dear all

Is there any way to give a user only create and delete 'view' permission
without including him as a member of db_ddladmin?

Thanks in advance.
Ken

GRANT CREATE VIEW TO .....

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
FAQ at: http://www.sql-server.co.uk/frmMain.asp

Thanks.

One more question.  If there is two people are able to create a view and
there is about 200 peopel will use any view created by them, how could I fix
an ownership of the view created by them (i.e. super.view1, super.view2)

Regards
Ken

Quote:> > Dear all

> > Is there any way to give a user only create and delete 'view' permission
> > without including him as a member of db_ddladmin?

> > Thanks in advance.
> > Ken

You can use the sp_changeobjectowner stored procedure to change ownership.
You might want your view creators to explicitly specify dbo as the owner
when they create views like:

CREATE VIEW dbo.someview
as
...

But my view creators are not member of db_owner or db_securityadmin.  What
should I do?

Regards
Ken

Quote:> You can use the sp_changeobjectowner stored procedure to change ownership.
> You might want your view creators to explicitly specify dbo as the owner
> when they create views like:

> CREATE VIEW dbo.someview
> as
> ...