SP Permisions

Oct 6, 2000

lets look in this simply SP:

---------------------------------

CREATE procedure test
as
Declare @cmd nvarchar(1000)

SET @cmd=N'Select * from Users'

exec sp_executesql @cmd

---------------------------------

User has rights only for executing SP in my DB. So my question is: why he can not execute this SP??? (error with permision on Users table). It is strange and now I have to add SELECT permision on USERS table for this user. This SP is running without problems:

CREATE procedure test1
as
Select * from Users

So why 'test' isn't running???

Fly

View 3 Replies


ADVERTISEMENT

Permisions To A View

Mar 18, 2008

Hi all,It is my understanding that you grant select permissions to a view for a user and they should be able to select from columns in that view. However I have done that and they receive permission denied when trying to select from that view. Am I missing something? I shouldn't have to grant permissions to that table or the database for them to select. Thanks in advanced for the help.

View 6 Replies View Related

Help Needed: Granting Create Table Permisions On Specific Schema Options

Sep 6, 2007

Having some trouble getting my head around setting access to specificschemas- here's my problem:I've created a specific schema that I only want certain users tocontrolProblem: Even though I give them full access....the cannot createtables under that schema...my code is below (flyer is the schema,eflyerAdmin is the role, and eflyer is the user):GRANTALTER,CONTROL,DELETE,EXECUTE,INSERT,REFERENCES,SELECT,TAKE OWNERSHIP,UPDATE,VIEW DEFINITIONON SCHEMA::flyerTO eflyerAdminGO-- Add an existing user to the roleEXEC sp_addrolemember N'eflyerAdmin', N'eflyer'

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved