Any way of.... 1

[mikeyb123]

I would like to run a report to find out who has what priviledges.

ie who and send/save audio who can log into query etc.

i can't see a predefined report to run or anything to print.

Will I have to run this against the sql direct?

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.

 

[DancingDave]

If you NiceUni 8.8 you can run a Profile Details report. This is fine as long as you use profiles!

We have eschewed profiles for assigning privileges to specific groups and then adding users to one (or more) of these groups e.g. form designer group, administrator group etc.

 

[mikeyb123]

We don't use profiles either.

I've had to run queries directly against the sql table to find the user privileges, but I can't seem to find the tables where the group privileges are kept.

The orginal query I wrote missed out people who have their priv's set at group level..


Back to the drawing board......

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.

 

[denazn]

This script will give you the privileges of a specific user:
Just change the loginname to whatever it is set for Administrator (currently set to nice)

declare @loginname varchar(25)
select @loginname='nice'
select c.description,b.description from system_privileges a, privilege_info b, privilege_groups c
where a.privilegeid=b.privilegeid and b.privilegetype=c.privilegetype
union
select c.description,b.description from user_privileges a, privilege_info b, privilege_groups c
where a.privilegeid=b.privilegeid and b.privilegetype=c.privilegetype
and a.userid=(select userid from user_info where loginname=@loginname)
union
select c.description,b.description from leader_privileges a, privilege_info b, privilege_groups c
where a.privilegeid=b.privilegeid and b.privilegetype=c.privilegetype
and a.groupid in (select groupid from group_leaders where userid=(select userid from user_info where loginname=@loginname))
union
select c.description,b.description from member_privileges a, privilege_info b, privilege_groups c
where a.privilegeid=b.privilegeid and b.privilegetype=c.privilegetype
and a.groupid in (select groupid from group_members where userid=(select userid from user_info where loginname=@loginname))

 

[mikeyb123]

Thanks for that,

I'll give this a go later today when I get a chance.

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.

 

[atrainer]

If you have NICE Universe web server, you can run a predefined report to see who has what privledges even if you do not use profiles

 

[mikeyb123]

atrainer,

we do have webserver but alas it doesn't work......another issue we have........

do you get alot of grief with your nice kit?

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.