June 26, 2006 at 4:58 am
Hi all,
I noticed that UID's between 0-4 are used by SQL internally (extract from master..sysusers below)
uid,name
0,public
1,dbo
2,guest
3,INFORMATION_SCHEMA
4,system_function_schema
My user tables only have the first three users, but when I add a user, UID's 3 and 4 are skipped and the UID jumps to userid 5
Can I safely accept that my own created user's will always have ID's > 5?
Thanks!
June 27, 2006 at 1:31 am
You can assume that UID > 5 are yours to use, unless the model database has had users added, then any new database will reflect the changes to model.
Andy
June 27, 2006 at 1:40 am
Thanks David!
Does this mean, If I create a standard SQL user with ID 5 in the model DB, all new databases will also have this user?
June 27, 2006 at 1:51 am
Model is template for every new database being created.
If you add a user to model, it will be propogated to all new database created.
June 27, 2006 at 1:55 am
Thanks guys!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply