Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 28th, 2004, 04:45 PM
Registered User
 
Join Date: Jan 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to create db user?

hi guys,

 i need a some info about the sql serve db user.my question is
using the syntax how to create the db users for particular databse


thanks&regards,
RamuSiddineni
 
Old January 29th, 2004, 12:53 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

You may want to check out the sp_addlogin, the sp_grantdbaccess, and the sp_grantlogin, depending on what you want to do.
 
Old January 30th, 2004, 06:34 AM
Authorized User
 
Join Date: Jan 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to ankur_vachhani
Default

Quote:
quote:Originally posted by ram_siddinen
 hi guys,

 i need a some info about the sql serve db user.my question is
using the syntax how to create the db users for particular databse


thanks&regards,
RamuSiddineni
        they syntax is
            SQL > create user user_name identified by passowrd
            SQL> grant dba to user_name













Similar Threads
Thread Thread Starter Forum Replies Last Post
Don't know how to execute sql script to create DB saxomopho BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 May 29th, 2007 12:09 PM
how to create XML from SQL DB with XSD. sasidhar79 XML 0 July 22nd, 2005 05:55 PM
Use DTS to create new MS Access DB? anya SQL Server DTS 2 February 25th, 2005 10:24 AM
User Control Db Connection farrukhmuneer .NET Framework 2.0 1 February 11th, 2005 03:42 AM
Create drop down list from SQL DB lshamba Classic ASP Databases 2 August 26th, 2004 10:49 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.