Re: GK - Persmission on each database ( objects )

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 14:39:58 +0530

Hi,

Details will be there in spt_values table in Master database.

0 - means it is Public

For Grantor and Grantee execute along with user_name function.

user_name(grantee),user_name(grantor)

For actadd and actmode join it with spt_values table.

Thanks
Hari
MCDBA

"GKramer" <anonymous@discussions.microsoft.com> wrote in message
news:96235761-C242-4D52-8FAE-22E3B6C8A424@microsoft.com...
> Hari,
>
> Thanks for your quick response, but where do the id's refer to ??? ( Where
can I find the ERD according to the sys-tables )
> 1 id int 4 0
> 0 grantee smallint 2 0
> 0 grantor smallint 2 0
> 0 actadd smallint 2 0
> 0 actmod smallint 2 0
>
> Guus Kramer