Hugo Kornelis (10/27/2010)
David Ziffer (10/27/2010)
USER_NAME() returns the name of the database user; SUSER_SNAME() returns the corresponding login.
Aha. This would work beautifully if RAP were using the SQL Server user name or login as its notion of a user. But it's actually using its own user table (TBadmUser) on the assumption that you will want a more granular way of designating users. For example the "anonymous" user for everyone who uses a web site, which is what SQL Server would see for all persons using the web sitein a typical public site setup, might not be too informative if you want to keep track of every individual using the site.
This user-table, by the way, is the only data that RAP requires your application to store; aside from this there are no requirements that you implement any particular tables.