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 2000 Forums
 SQL Server Development (2000)
 Permission on multiple entities

Author  Topic 

X-Factor
Constraint Violating Yak Guru

392 Posts

Posted - 2005-04-13 : 20:13:11
Hi,

SQL Server has multiple types of objects. (i.e. tables, sps) and you can set permissions on each of them.

Is the permissions data stored in a single table or is there one table of permissions for each type of item?

Cheers,

XFactor.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-04-13 : 20:34:10
DBName.dbo.syspermissions

Tara
Go to Top of Page
   

- Advertisement -