Database

<br />
/* ---------------------------------------------<br />
 * Add an NT login to this database from the <br />
 * NT Domain.<br />
 */<br />
CREATE TRIGGER User_Permissions_Insert<br />
  ON dbo.[User Permissions]<br />
 FOR INSERT<br />
AS<br />
	<br />
	DECLARE @DOMAIN VARCHAR(200),<br />
	        @FULL_USERNAME VARCHAR(255)<br />
	<br />
	<br />
       SELECT @DOMAIN = ISNULL([Parameter Value],'')<br />
	  FROM dbo.[PUMA Parameters]<br />
	 WHERE [Parameter Name] = 'NT Domain'<br />
	<br />
	IF @DOMAIN = ''<br />
	   SELECT @FULL_USERNAME = [User Name]<br />
             FROM inserted<br />
	ELSE<br />
	   SELECT @FULL_USERNAME = LTRIM(@domain) + '\' + Ltrim([User Name])<br />
             FROM inserted<br />
<br />
<br />
        -- Add the NT login to the database logins list<br />
        EXECUTE sp_grantlogin @FULL_USERNAME<br />
<br />
        -- And grant them access to the current database<br />
        EXECUTE sp_grantdbaccess @FULL_USERNAME<br />
<br />
<br />
	RETURN