The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
in
Home SS SLUG Forums Articles Photos Downloads
SQL Server Universe.com » SQL Server Components » T-SQL » Privileges

Privileges

Last post 03-07-2008, 17:52 by G.R.Preethiviraj Kulasingham. 1 replies.
Sort Posts: Previous

  • Privileges

    		 03-06-2008, 17:13

    manishkumar1980
    • Joined on 09-09-2008
    • Posts 14
    • Points 0
    • Top 10 Contributor
      Male
    Reply Quote

    I want to grant all privileges on my objects to other users. How is it possible without using ALL option.

     

    With Regards

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

    Manish

     

  • Re: Privileges

    		 03-07-2008, 17:52

    G.R.Preethiviraj Kulasingham
    • Joined on 04-02-2007
    • Colombo
    • Posts 28
    • Points 0
    • Top 10 Contributor
      Male
    Reply Quote

    Hi Manish,

    What do you mean by "all priviledges" and "My objects"?  Is it that you own a schema and objects are in that schema and you want them to have control over the objects?

    I Believe you are refering in SLQ Server 2005. You can do that either by giving control priviledge to the schema.

    GRANT CONTROL ON SCHEMA:: <MySchema> To <User>

    Is this what you wanted?

     

    G.R.Preethiviraj Kulasingham MCITP: DBA
    http://preethiviraj.blogspot.com/
    Plan Your Work and Work Your Plan!
View as RSS news feed in XML

(Best viewed with a resolution of more than 1024 * 768)
Powered by Community Server, by Telligent Systems