DBO rights

hi
As per baselining requirement, we need to drop dbo rights of the users
and assign
SELECT,INSERT,UPDATE, DELETE, EXECUTE rights on tables, SPs, views,
functions in the database.
Request you to pls revert whether dropping the dbo priviledge would affect
the functionality of database in any way.
RAHULHi Rahul,
A database always need to have an owner, and you will always have a dbo user
in a database.
Removing other users from the db_owner role should not affect the
functionality of your application however, if it is properly designed.
Jacco Schalkwijk
SQL Server MVP
"RAHUl" <anonymous@.discussions.microsoft.com> wrote in message
news:1EA6990D-BC8D-4AB4-B07E-9B617C6C9EF7@.microsoft.com...

quote:

---

> hi
> As per baselining requirement, we need to drop dbo rights of the users
> and assign
> SELECT,INSERT,UPDATE, DELETE, EXECUTE rights on tables, SPs, views,
> functions in the database.
> Request you to pls revert whether dropping the dbo priviledge would affect
> the functionality of database in any way.
> RAHUL

---