Help with roles in SQL Server Reporting Services 2005

I know how to create roles but how do you add users to them, and then roles to different levels? This section of MSDN doesn't tell much

http://msdn2.microsoft.com/en-us/library/ms157397(en-US,SQL.90).aspx

You add users to the roles by navigating to the item you wish to secure. You then click on the property tab, then the security sub-tab. From here you can click on 'New Role Assignment'. Now you can add a user or group and assign the role you wish for them to have on this item.

You can also do this at the site level for the site level permissions. Click on 'Site Settings' in the upper right hand corner. Then click on 'Configure site-wide security'. From here you can again add users and assign them different system roles.

-Daniel

Help with query

Hi guys, I wonder if I may ask for your help here.
I have two tables RoleNames and Roles where RoleNames are the available
roles and Roles are the Roles which the users 'may' have.
RoleName
ID int
RoleName char(10)
Roles
RoleID int
user_name NVCHAR
I need to find our what roles a give user does not have. I'm struggling with
what I am sure is a simple query. Any help is appreciated.Please post *real* DDL and sample data, so we don't have to guess what the
relationships between these two table are.
Also consider normalizing your model some more.
There are two entities and a many-to-many relationship so, I guess you're a
table short. Do not design tables until you have a sound concept and logical
model.
Entities:
1) users;
2) roles.
Relationships:
1) users in roles.
ML
http://milambda.blogspot.com/|||What makes you think this is a many to many relationship ?
RoleNames PK can appear Many Time in Roles FK. - This is pretty simple
stuff. I have not seen you come up with an answer to anything yet so please
stop replying to my posts unless you can offer some solution.
"ML" <ML@.discussions.microsoft.com> wrote in message
news:A09D1C25-9164-4C79-A900-12DDC7F343EA@.microsoft.com...
> Please post *real* DDL and sample data, so we don't have to guess what the
> relationships between these two table are.
> Also consider normalizing your model some more.
> There are two entities and a many-to-many relationship so, I guess you're
> a
> table short. Do not design tables until you have a sound concept and
> logical
> model.
> Entities:
> 1) users;
> 2) roles.
> Relationships:
> 1) users in roles.
>
> ML
> --
> http://milambda.blogspot.com/|||In fact just forget it, Ive worked it out for myself without your useless
input.
"ML" <ML@.discussions.microsoft.com> wrote in message
news:A09D1C25-9164-4C79-A900-12DDC7F343EA@.microsoft.com...
> Please post *real* DDL and sample data, so we don't have to guess what the
> relationships between these two table are.
> Also consider normalizing your model some more.
> There are two entities and a many-to-many relationship so, I guess you're
> a
> table short. Do not design tables until you have a sound concept and
> logical
> model.
> Entities:
> 1) users;
> 2) roles.
> Relationships:
> 1) users in roles.
>
> ML
> --
> http://milambda.blogspot.com/|||Good.
ML
http://milambda.blogspot.com/|||> stop replying to my posts
Ok.
ML
http://milambda.blogspot.com/