MSDN and some books like

SQL Server for dummies are good for the initial start:cool:.

see if you can use procedure sp_send_dbmail

where you can change your Subject of email according to requirement

and append your server name or address

You can give them alter permissions and exec permissions as this will

Allow them to develop the procedure and also they can unit test it.

EXEC sp_MSforeachdb 'use [?];

select * from information_schema.columns

'

😎

SESSION

Session tells the server, how to fetch the metadata from repository for the specified mapping (data flow).

TASK

Task is a particular work that is for eg. Assignment Task is used...

IF EXISTS (SELECT 1 FROM sys.database_principals WHERE name ='USerName')

DROP USER [USerName]

CREATE USER [USerName] FOR LOGIN [LoginName]

EXEC sp_addrolemember 'db_datareader','USerName'

You can also refer MSDN forums for user permissons

Hey ,

i think going with

SQLSERVERCENTRAL books is good beside this

for some Quick learning you can use

SQL server 2008 for dummies

and going through blogs of Experienced DBA

will do...

USE Databasename;

EXECUTE AS USER = 'username';

SELECT *

FROM sys.fn_my_permissions('procedurename ', 'object')

ORDER BY subentity_name, permission_name ;

GO

This script can be use d as base to identify permission on a stored...

I think we can create a view than we can

assign permission to a particular user for that view

GRANT SELECT ON view-name TO user-name

GRANT VIEW DEFINITION ON view_name TO...