Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Create Database User

By Vinay Kumar,

 

Give the parameter values according to your requirement.

 

Parameter Information:-

BEFORE EXECUTE SCRIPT, PLEASE CHANGE THE VALUE OF FOLLOWING

@NewUser_Name 'Put the new user name here'?

@NewUser_Password 'Put the password for new user'

@DatabaseName 'Put the database name, where you want to create user'

@NewSchema_Name 'Put the new schema name'

Note :- IF @NewSchema_Name not provided or @NewSchema_Name is null then default schema is dbo.

 

 

Please post your comments and suggestion.

 

Thanks I advance

Vinay Kumar

Total article views: 1667 | Views in the last 30 days: 9
 
Related Articles
FORUM

error while trying to move objects from dbo to new schema

Hi all, I am trying to move database objects from dbo shcema to new schema in sql 2008 using ...

BLOG

Transferring Table Types

An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you ...

FORUM

Need help changing Owners

Hi, I have alot of views within a database. I know how to change the owner of the view itself but I...

FORUM

Can some tell me how to transfer schema of "User Defined Table Type" (UDTT) in SQL 2008?

I have cloned a database from another database and able to change the schema for all the objects exc...

FORUM

Change Object Ownership

SQL Server 2005 newbie. User created objects which, instead of dbo, are associated with his accou...

Tags
security    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones