×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Any way of....

Any way of....

Any way of....

(OP)
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.

RE: Any way of....

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.

RE: Any way of....

(OP)
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.

RE: Any way of....

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))

RE: Any way of....

(OP)
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.

RE: Any way of....

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

RE: Any way of....

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close