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
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
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