4 Replies Latest reply on Nov 14, 2016 5:52 AM by gregor.honer

user access to a specific space

hhaeffner Oct 27, 2016 5:33 AM

Dear support team,

Could you please provide me a db query how to find out which users have access to a specific space.

Our environment: Jive 8.0.2 on prem. DB Oracle 11.2

Many thanks

Heinrich

Re: user access to a specific space

gregor.honer Oct 28, 2016 6:39 AM (in response to hhaeffner)

Hey Heinrich,

Have you seen this question SQL query for seeing who has viewed a space? ?
Would that help?
Maybe not 100% what you are after but should not be that hard to adapt
Like Show 0 Likes(0)

Actions
- Re: user access to a specific space
  
  hhaeffner Oct 28, 2016 7:10 AM (in response to gregor.honer)
  
  Hi Gregor,
  
  unfortunately not.
  I want to query the users which have access to a specific space.
  
  Thanks
  Heinrich
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: user access to a specific space
    
    gregor.honer Oct 31, 2016 12:50 AM (in response to hhaeffner)
    
    Ok let me look into this once again and see if I can help.
    
    Like Show 0 Likes(0)
    
    Actions
Re: user access to a specific space

gregor.honer Nov 14, 2016 5:52 AM (in response to hhaeffner)

Hey Heinrich,

Could you try this?

SELECT * FROM jiveentitlement WHERE objecttype = 14 and objectid = <spaceid> AND (userid = <userid> OR groupid IN (SELECT groupid FROM jivegroupuser WHERE userid = <userid>))

We dont have space members in the same way as social group members, we determine access based on entitlements and the above query will return all users or usergroups that have an entitlement on a given space.

Thanks
-Gregor
Like Show 0 Likes(0)

Actions