HOW TO GET THE PERMISSION ON OBJECTS

Dear Friends
We have setup a server with replicaiton which will work as a backup server
now the problem i have is permission on the objects as the same is created a
s
new sql database there are no permission on the objects, I have created the
same roles in the database now i want to give the exactly the same permissio
n
to the roles form the parent server.
Is there any easy way say query which can copy the same permission from the
parent server.
your earlier reply would be a great help.
Thanks and best regards
SharadSELECT
QUOTENAME(TABLE_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)
FROM
INFORMATION_SCHEMA.TABLES
WHERE EXISTS
(
SELECT *
FROM sysindexes
WHERE id =
OBJECT_ID(QUOTENAME(TABLE_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)) AND
indid IN(0,1)
)
"Sharad2005" <niitmalad@.yahoo.co.uk> wrote in message
news:F6C8BE64-0A6D-4BE1-B1EE-E91E8EAB588A@.microsoft.com...
> Dear Friends
> We have setup a server with replicaiton which will work as a backup server
> now the problem i have is permission on the objects as the same is created
as
> new sql database there are no permission on the objects, I have created
the
> same roles in the database now i want to give the exactly the same
permission
> to the roles form the parent server.
> Is there any easy way say query which can copy the same permission from
the
> parent server.
> your earlier reply would be a great help.
> Thanks and best regards
> Sharad