Sql server forum role db_owner

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
boogie Members Profile Find Members Posts Newbie Joined: 17 May 2003 Status: Offline Points: 4	Post Options Post Reply Quote boogie Report Post Thanks(0) Quote Reply Topic: Sql server forum role db_owner Posted: 17 May 2003 at 10:25pm
	Is it necessary to have the user name for the sql server connection to be in the role of db_owner? I am trying to limit the amount of permissions this user name should have on the database. After creating the database with the script. Can I just switch the role for this user name to db_datareader and db_datawriter without there being any adverse effects with stored proceedures or other database functions required by the forum.

Bunce Members Profile Find Members Posts Senior Member Joined: 10 April 2002 Location: Australia Status: Offline Points: 846	Post Options Post Reply Quote Bunce Report Post Thanks(0) Quote Reply Posted: 18 May 2003 at 2:09am
	I would think that would be OK. Reader and Writer should have the necessary permissions to fulfill all the WWF functions. Shouldn't be too hard to test though..
	There have been many, many posts made throughout the world... This was one of them.

fernan82 Members Profile Find Members Posts Mod Builder Group Joined: 17 November 2002 Location: United States Status: Offline Points: 362	Post Options Post Reply Quote fernan82 Report Post Thanks(0) Quote Reply Posted: 18 May 2003 at 1:58pm
	I've tried to do that and got errors
	FeRnAN

Bunce Members Profile Find Members Posts Senior Member Joined: 10 April 2002 Location: Australia Status: Offline Points: 846	Post Options Post Reply Quote Bunce Report Post Thanks(0) Quote Reply Posted: 18 May 2003 at 4:51pm
	and... the errors will tell you what you need permissions to alter. I'd check if you have EXEC permissions on the stored procs.
	There have been many, many posts made throughout the world... This was one of them.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.