Afficher un message
Vieux 06/09/2007, 02h14   #1
gdev
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut needed: Granting Create table permisions on specific Schema Options



Having some trouble getting my head around setting access to specific
schemas- here's my problem:

I've created a specific schema that I only want certain users to
control


Problem: Even though I give them full access....the cannot create
tables under that schema...my code is below (flyer is the schema,
eflyerAdmin is the role, and eflyer is the user):

GRANT
ALTER,
CONTROL,
DELETE,
EXECUTE,
INSERT,
REFERENCES,
SELECT,
TAKE OWNERSHIP,
UPDATE,
VIEW DEFINITION
ON SCHEMA::flyer
TO eflyerAdmin
GO
-- Add an existing user to the role
EXEC sp_addrolemember N'eflyerAdmin', N'eflyer'

  Réponse avec citation
 
Page generated in 0,05078 seconds with 9 queries