SQL 2005 but compatibility 2000

From: "Ch." <trotroyanas@xxxxxxxxxxx>
Date: Fri, 8 Sep 2006 13:45:44 +0200

Hi,

i have a role and user to this role !

a role have select, update, delete, insert, execute permission
the not have permission to create or alter (table, procedure,view ...)

and X procedure have a command xp_cmdshell, i want to put this right to my
role or user !
my server is 2005 but the database is compatibility to 2000.

how can i do to put the right on my role ?

thank's
Ch.

.

Prev by Date: Re: unable to delete data in table
Next by Date: Re: How to switch identity using stored procedure
Previous by thread: Allow Developer to Design tables, but not be owner?
Next by thread: Re: How to switch identity using stored procedure
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL2000 UserPermissions for Database
... EXECUTE permission denied on object 'usp_ListDatabasesForLogin', ... database 'databaseA', owner 'dbo'. ... GRANT EXEC ON dbo.usp_ListDatabasesForLogin TO userx ...
(microsoft.public.sqlserver.security)
Re: Stored procedure to drop and create table for end user
... which has a user called benetest with the password ... which has execute permission on when i execute BENESP_TEST like ... exec BENESP_TEST 'test' ... depending on the database... ...
(microsoft.public.sqlserver.programming)
RE: Update changes
... > back to database with stored procedure? ... > database tables and execute permission on Stored procedures. ...
(microsoft.public.dotnet.languages.vb)