quote:

---

Well, the easiest way to meet all the requirements would be to have the users alias to dbo. DBO will have all the right's you want, here. Unfortunately, it seems that you can't add an alias a role.

Alternatively, how about creating an account LIKE guest (don't use guest, since it is a default, and anyone can try and hack it), and adding the new "guest2" userid to db_owner role ?

HTH

*#&#* *#&#* *#&#* *#&#*

Chaos, Disorder and Panic ... my work is done here!

---

IF OBJECTPROPERTY(OBJECT_ID(N'GrantPermissions'), N'IsProcedure') = 1 
 DROP PROCEDURE GrantPermissions
GO

CREATE PROCEDURE GrantPermissions (@name NVARCHAR(128)) AS
 SET NOCOUNT ON
 
 DECLARE @executes TABLE (SQL NVARCHAR(4000))
 DECLARE @sql NVARCHAR(4000)
 
 INSERT INTO @executes (SQL)
  SELECT 'GRANT SELECT,UPDATE,DELETE ON ' +
         '[' + TABLE_CATALOG + '].[' + TABLE_SCHEMA + '].[' + TABLE_NAME + '] ' +
         'TO [' + @name + ']'
    FROM INFORMATION_SCHEMA.TABLES
   WHERE TABLE_TYPE = 'BASE TABLE'

 INSERT INTO @executes (SQL)
  SELECT 'GRANT EXECUTE ON ' +
         '[' + ROUTINE_CATALOG + '].[' + ROUTINE_SCHEMA + '].[' + ROUTINE_NAME + '] ' +
         'TO [' + @name + ']'
    FROM INFORMATION_SCHEMA.ROUTINES
   WHERE ROUTINE_TYPE = 'PROCEDURE'

 WHILE EXISTS(SELECT * FROM @executes)
  BEGIN
   SELECT @sql = SQL
     FROM @executes

   EXEC sp_executesql @sql

   DELETE
     FROM @executes
    WHERE SQL = @sql
  END
GO