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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 permission window

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2007-02-16 : 05:33:05
Running sql server 2005 standard edition (SP1).
Server properties, permissions window seems to be different to what it should be.
In this window I do not see System Administrator and System User column. I see a different window i.e. permission, Grantor, Grant, WithGrant, Deny columns.
Any thoughts please?
Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-02-16 : 13:08:23
You've stated what you see in the window, but you haven't told us what you want to do. Once we know what you want to do, we can tell you where to find it in SSMS.

Tara Kizer
Go to Top of Page

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2007-02-17 : 08:22:36
Would like to set standard users and set permissions to them.
Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-02-19 : 01:51:18
First start in the Security section to create your logins. Then you can either choose to set the database access in the user mapping part when creating the login or you can go to Security after you have expanded the database.

Tara Kizer
Go to Top of Page
   

- Advertisement -