开发者

create new roles in sql server 2008

开发者 https://www.devze.com 2023-01-17 02:23 出处:网络
I have created a database system for a cms for a news website. I want to have only 4 roles in my db system : Admin, Author, Editor and Guest ( who only read the web pages). But there 开发者_StackOverf

I have created a database system for a cms for a news website. I want to have only 4 roles in my db system : Admin, Author, Editor and Guest ( who only read the web pages). But there 开发者_StackOverflow社区are some pre-defined roles in every db system like sys and db_owner and… and they are not removable but I want the only 4 roles I mentioned above. How can I aim this goal? thanks


ah, you cannot!

Also I do not think you will need to tweak the database system. Rather, architect a good solution for your application/frontend/website.


as far as i am aware, you can't modify those roles (besides adding logins to them). instead of working around them, you could try using them, it might make life a little bit easier.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号