Query to set user permissions without using Admin Tool

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
Tri
Posts: 288
Joined: Wed Dec 22, 2004 11:10 am

Query to set user permissions without using Admin Tool

Post by Tri » Fri Jul 15, 2005 7:53 am

Server 3.07.

Is it possible to do the following in a batch by executing a query against sgvault DB:

1. Set user default permissions to nothing (instead of the default RCA).

2. Enable/Disable access to all repositories for a all users.

3. Enable/Disable access to a specific repository for a set of users
(providing that RepositoryID and all UserIDs are known)

Thanks in advance.

jclausius
Posts: 3706
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » Fri Jul 15, 2005 9:50 am

I don't want to post SQL Queries, as these operations should normally be done in the Admin Tool. I'll be sending you these queries by email.
Jeff Clausius
SourceGear

Locked