SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 GRANT CREATE TABLE ...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

noamg
Posting Yak Master

Israel
197 Posts

Posted - 07/02/2008 :  09:16:59  Show Profile  Reply with Quote
I need:
grant create table to LoginCS, but on the schema Games.
like:

grant create table on schema::Game to LoginCS
but this is syntax error ...

any idea ?


Noam Graizer

sodeep
Flowing Fount of Yak Knowledge

USA
7173 Posts

Posted - 07/02/2008 :  09:19:50  Show Profile  Reply with Quote
Is this SQL login? You should be able to . Otherwise do it from GUI.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 07/04/2008 :  20:39:44  Show Profile  Reply with Quote
Syntax is:

grant create table to LoginCS
Go to Top of Page

noamg
Posting Yak Master

Israel
197 Posts

Posted - 07/06/2008 :  03:57:22  Show Profile  Reply with Quote
but how to allow only on a specific schema ?

Noam Graizer
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 07/06/2008 :  13:21:59  Show Profile  Reply with Quote
Add used to that schema only.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000