Re: SQL 2005 - Schema permissions

From: Joe Yong (NO_jyong_SPAM_at_scalabilityexperts.com)
Date: 10/19/05

  • Next message: Joe Yong: "Re: sa loginname being hacked" 
    Date: Tue, 18 Oct 2005 22:46:59 -0500

    Have you looked at GRANT ALTER? Let's the recipient alter, create and drop
    the securable (schema or object) but not change the ownership. There is a
    GRANT CONTROL but that's probably too much privilege.

    joe.

    "Carlos Eduardo Selonke de Souza"
    <CarlosEduardoSelonkedeSouza@discussions.microsoft.com> wrote in message
    news:174428B4-DD7F-4BD6-9DC1-50810A042334@microsoft.com...
    > Hello
    >
    > I am trying to use the new schema model on SQL 2005 to control permissions
    > for users on my database.
    >
    > I have two users on my database (User1 and User2) and a schema called
    > TestSchema.
    > I want to give permissions to both users to create/drop/alter objects
    > (procedures, views, tables) only on the TestSchema.
    > I read that a user can own a schema so it can control it. I also notice on
    > Management Studio that only one user can own a schema.
    >
    > Is it possible to more than one user have "full control" of a schema? And
    > how to do it on SQL 2005?
    >
    > PS: I used to post questions about SQL 2005 on the beta newsgroup, but
    > today
    > when I tried to access it I was redirect to the MS Newsgroups.
    >
    > Regards
    >
    >
    >
    >
    > --
    > Carlos Eduardo Selonke de Souza
    > http://carlos.geekbunker.org

  • Next message: Joe Yong: "Re: sa loginname being hacked"

    Relevant Pages

    • Re: Permission problems user cant create a table
      ... understood that the OP wanted to create a table without specifying the ... schema, as it must ne a member at least of db_owner fixed database role ... CREATE USER MyUser WITHOUT LOGIN ... GRANT ALTER ON SCHEMA::Sales TO MyUser; ...
      (microsoft.public.sqlserver.security)
    • Re: Permission problems user cant create a table
      ... The schema is optional. ... CREATE USER MyUser WITHOUT LOGIN ... GRANT ALTER ON SCHEMA::Sales TO MyUser; ... I understood that the OP wanted to create a table without specifying the schema, as it must ne a member at least of db_owner fixed database role ...
      (microsoft.public.sqlserver.security)
    • Re: Permission problems user cant create a table
      ... But the user will still specify schema name to create a table. ... say the dbo schema it doesnt automatically mean they have permissons ... GRANT ALTER ON SCHEMA::Accounting TO MyUser; ...
      (microsoft.public.sqlserver.security)
    • SQL Adapter Disassembling Result Sets & Dynamic Parameters
      ... properties of the schema returned in my orchestration. ... Also after processing all the records returned by SQL adapter in my ... from the toolbox drag an xml disassembler ...
      (microsoft.public.biztalk.general)
    • SQL Adapter Disassembling Result Sets & Dynamic Parameters
      ... properties of the schema returned in my orchestration. ... Also after processing all the records returned by SQL adapter in my ... from the toolbox drag an xml disassembler ...
      (microsoft.public.biztalk.server)