July 24, 2008 at 3:23 pm
What are the default databases access will be having for a new user when created in sql server.
July 24, 2008 at 3:38 pm
Whatever rights you've given "public", which is pretty little by default.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 24, 2008 at 10:44 pm
I assume you mean login created. By default, only those database that have a guest user will allow the new login to access them. If you create a user (mapping the login to it) in a database, then as mentioned above, only public access is given by default.
You have to explicitly assign rights to roles, which you should then add users to.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply