Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2008-01-09 : 14:03:57
|
| I created a new login name. I checked 3 databases in User Mapping. I tried to mimic an existing login name. When I right clicked at the database and selected Properties. I selected the Permission tab at the left. It showed both login names under users or roles. I selected the existing login name and clicked the Effective Permissions button. The login has all permissions: Alter, Create, Select, Insert, Update, Delete, Execute, Connect, etc. When I selected the new login name and clicked the Effective Permission button, the login has only Connect. Why the new login name does not have all other permissions? And how can I assign to it?Thanks.DanYeung |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-09 : 16:28:14
|
| you need to grant roles to the login for permissions to be assigned. there are fixed roles and custom roles. fixed roles are already defined, and chances are the existing login has the 'dbo' privilege assigned to it.look roles up in BOL for more info.-ec |
 |
|
|
|
|
|
Permission for the new created login name