• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

Create database login and user using SMO

I am trying to create Login and user programatically  using SMO sql 2008
if the login ( i.e testlogin) already exist  in the database then i want to creat a user(i.e test user) and give read only access and map this login and user ..
if the login is new then create a login and user and give the read only access..
how can i do this programatically using SMO sql 2008?

0
jung1975
Asked:
jung1975
1 Solution

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now