|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.waveset.adapter.SQLServerResourceAdapter.SQLServerAccountIterator
The implementation of the AccountIterator returned by getAccountIterator. This implementation iterates over the results of the sp_helplogins procedure, which performs a convenient join over the syslogins and sysusers tables. Sigh, it returns two result sets, the first one has just the logins, and seemingly only those in the master database. Columns are: LoginName, SID, DefDbName, DefLangName, AUser, ARemote The rowcount seems to be the same as the sys * The second result set has what we need to associate the accounts and roles with each login. Columns are: LoginName, DBName, UserName, UserorAlias UserOrAlias is "User" if this represents a user account or "MemberOf" if this is a group membership row. Punting right now and just createing users for each login.
Field Summary |
Fields inherited from interface com.waveset.adapter.AccountIterator |
code_id |
Constructor Summary | |
SQLServerResourceAdapter.SQLServerAccountIterator(java.sql.Connection con,
SQLServerResourceAdapter adapter)
Construct the iterator, run the query, and load the first user. |
Method Summary | |
void |
close()
Release resources required for the iteration. |
boolean |
hasNext()
Return true if there are more users. |
WSUser |
loadUser()
Returns the next user object. |
WSUser |
next()
Returns the next user object. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public SQLServerResourceAdapter.SQLServerAccountIterator(java.sql.Connection con, SQLServerResourceAdapter adapter) throws WavesetException
If we hit an error, auto-close so the caller doesn't have to worry about it.
Method Detail |
public void close()
close
in interface AccountIterator
public boolean hasNext() throws WavesetException
hasNext
in interface AccountIterator
WavesetException
public WSUser next() throws java.util.NoSuchElementException
next
in interface AccountIterator
java.util.NoSuchElementException
public WSUser loadUser() throws WavesetException
WavesetException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |