SQL Server Performance

Assigning roles

Discussion in 'T-SQL Performance Tuning for Developers' started by cjai_prakash, Jul 29, 2004.

  1. cjai_prakash New Member

    Hi

    I have created two users namely user1 & user2 and assigned the roles as public.

    The tables created by the user1 are not accessible by the user2.

    How to create the common tables for all users ?



    Cheers

    Jayaprakash Chandrasekaran
  2. satya Moderator

    No need to create common tables and to do so refer to books online for GRANT Statement topic in order to grant permissions on the tables for both the users.

    One of the example in BOL:
    This example grants multiple statement permissions to the users Mary and John, and the CorporateBobJ Windows NT group.

    GRANT CREATE DATABASE, CREATE TABLE
    TO Mary, John, [CorporateBobJ]



    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page