How to remove domain admins from SRS

Hi
In our IT dept all IT users are members of the domain admin group (not my
idea). Is there a way to prevent them from seeing reports/folders? We only
want admins to see reports if they are given explicit permissions.
thanksThe reason this is happening is not because they are in the domain admin
group, it is because the domain admin group is in the local Adminstrators
group. This is the group that RS uses. So, on the server that is running RS
remove the domain admin group from the local group. Create new groups that
you put in the appropriate users and then assign the appropriate roles. Only
put true RS admins in the local admin group.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"darwin" <darwin@.discussions.microsoft.com> wrote in message
news:6722153F-A8A5-4B77-8DFA-772ADCFB7145@.microsoft.com...
> Hi
> In our IT dept all IT users are members of the domain admin group (not my
> idea). Is there a way to prevent them from seeing reports/folders? We
> only
> want admins to see reports if they are given explicit permissions.
> thanks|||Thanks Bruce ;)
"Bruce L-C [MVP]" wrote:
> The reason this is happening is not because they are in the domain admin
> group, it is because the domain admin group is in the local Adminstrators
> group. This is the group that RS uses. So, on the server that is running RS
> remove the domain admin group from the local group. Create new groups that
> you put in the appropriate users and then assign the appropriate roles. Only
> put true RS admins in the local admin group.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "darwin" <darwin@.discussions.microsoft.com> wrote in message
> news:6722153F-A8A5-4B77-8DFA-772ADCFB7145@.microsoft.com...
> > Hi
> > In our IT dept all IT users are members of the domain admin group (not my
> > idea). Is there a way to prevent them from seeing reports/folders? We
> > only
> > want admins to see reports if they are given explicit permissions.
> >
> > thanks
>
>

How to remove a recursive relationship

Hi,
I am building a db that contains folders with all info about a folder.
For example :
folder_id PK
folder_name
folder_size etc.
In my case, each folder may have 0 or more childern. A child itself
is unlikely going to have any children in itself. This is a recursive
relationship I'd like to remove in my DB design.
How can I represent this relatonship?
Thank you, DinoPlease elaborate on the issue, if you could. I'm not sure I understand; a
child folder which is the only child of another folder is unlikely to have
any children of its own?
How are you modelling the hierarchy itself? It doesn't HAVE to be recursive
(although that is one option). There are also hierarchical modelling
techniques like enumerated path and nested sets (search Google and you'll
get plenty of info on each) that are not recursive.
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:p2sj50p0pcihhqo9i4f0g0kv1thl98see7@.
4ax.com...
> Hi,
> I am building a db that contains folders with all info about a folder.
> For example :
> folder_id PK
> folder_name
> folder_size etc.
> In my case, each folder may have 0 or more childern. A child itself
> is unlikely going to have any children in itself. This is a recursive
> relationship I'd like to remove in my DB design.
> How can I represent this relatonship?
> Thank you, Dino|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:335813
I am gonna do it just like:
folder_id PK
parent_folder_id FK
folder_name
this way if the folder has a parent I will know it. I think this
solves the problem.
Thanks anyways,
Dino
On Thu, 18 Mar 2004 14:10:38 -0500, "Adam Machanic"
<amachanic@.air-worldwide.nospamallowed.com> wrote:

>Please elaborate on the issue, if you could. I'm not sure I understand; a
>child folder which is the only child of another folder is unlikely to have
>any children of its own?
>How are you modelling the hierarchy itself? It doesn't HAVE to be recursiv
e
>(although that is one option). There are also hierarchical modelling
>techniques like enumerated path and nested sets (search Google and you'll
>get plenty of info on each) that are not recursive.
>
>"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
> news:p2sj50p0pcihhqo9i4f0g0kv1thl98see7@.
4ax.com...
>