Assigning roles | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Assigning roles

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
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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.