I have given required permission with these commands

create login 'james' with password = 'xxx'

go

use MyDB

go

create user james for login james

go

grant select on [vw_paymen] t to james

after that

i have log...

I am bit confusing on this process...

Can anyone clarify that i just want a user to see only one view in specific database..rest of all will be hide from user...

THank you all..

how far is it secured..like if i give access with username to another client with public IP then does it safe for our data..??

how can i acheive high...

can't i make it disable...and other databases also...though he is not able to acess i want to make them disable..is it possible?

it doesn't have any permission on any other database...i want to disable security,managment to that user

please check the attachment user can see 'sa'(i want to restrict it)

it has connect,select,execute permissions only..

after login with taht user i can see systemtables,system stored procedures,another users(even i can modify it) under particular database...but i want to restrict that..

its not one time process..it has to push data for every minute or 5 minute..so i need to connect through liked server...another server is on public IP

i want to push few tables or data to anther application...do we need to use linked servers?

op_registration data

SET IDENTITY_INSERT [dbo].[OP_Registration111] ON

INSERT INTO [dbo].[OP_Registration111] ([Id], [FacilityId], [MRNO], [OPNO], [RegistrationDate], [VisitNumber])

SELECT 31, 2, N'MR-02-0613-0001', N'OP-02-0613-0001', '2013-06-01 09:48:00.000', 1

UNION ALL

SELECT 32, 2, N'MR-02-0613-0001', N'OP-02-0713-0002', '2013-07-07 09:51:00.000',...

i need to get reports based on given values..if i enter today's date i need to get all data till today..reports can be requested any time

thank you for reply...

I am using sql server 2008 R2...

can we use retrive data from microsoft word to any application..as same as database it has to bind to application

thank you for your reply

here it has huge data and it has to provide high security of data..

Thank u Ed Wagner