Rights for
-
Hi Everyone,
I have a question regarding rights.
Go to database -> Views -> Design View.
I have some application administrators that ar DBWriter. When i give them the right to create a view, they still cannot use the 'Design view' function in SQL server.
I don't want to give them all the rights, so DBO is not an option.
Does anybody know which right i have to give so they can use the 'Design View' function.
Kind regards,
André
-
to use the GUI, you need dbo rights.
to do the same via script, you only need db_ddladmin.
sb_dataReader and db_dataWriter are for data only, not for DDL changes.
the GUI requires more rights because the tools and logic it requires make that assumption just to avoid unnecessary errors.
if you don't ghave dbo on the object selected in object explorer, you get this error:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Thanks man. I was thinking about DDL but i wasn't 100% sure.
I'm going to use this role.
Kind regards,
André
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply