Hello all.. its been awhile and I have been way from SQL for a couple years.. Getting back into it now. Quick question on permissions. If someone is granted db_owner and db_datareader on a database, is their effective permissions db_owner?
Just verifying that the permissions here are not setup as least restrictive
Thank you
Steve
Essentially yes. db_owner can pretty much do anything in the database - which would include select against all tables and views like db_datareader.
Sue