Solved

Creating Databse!

Posted on 2004-04-14
7
201 Views
Last Modified: 2010-05-02
Hi All,

How to determine whether the MS SQL Server user has the premission to create database programmatically?

With Regards,
A.Ilamparithi.
0
Comment
Question by:callilam
  • 5
7 Comments
 
LVL 8

Expert Comment

by:dds110
ID: 10824312
Error trapping!

You could attempt the create database functionality.  If it errs out, then he/she doesn't have the permission.  Otherwise, he/she does.  You'll need to determine the exact error number from SQL Server if you want to provide specific error handling.

Example:

Public Function CreateANewDB()
On Error GoTo err_create:
'code to create the new db

exit_create:
'clean up any used variables and close the function
Exit Function

err_create:
MsgBox Err.Description,,Err.Number
Resume exit_create:
End Sub


HTH
0
 
LVL 8

Expert Comment

by:dds110
ID: 10877402
Hello?
0
 

Author Comment

by:callilam
ID: 10877698
hi,

I dont want to create a database. But, just want to know whether the user has the previledge to create the database.

Also, It is not possible to create database from VB.

With Thanks,
A.Ilamparithi.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 8

Expert Comment

by:dds110
ID: 10997862
OK, so try to create the database anyway.  If it's created, great, the user has access to create databases.  Then delete the database.

In addition, it is too possible to create a database from vb.  However, at this time i'm not sitting in front of a computer with vb installed so I can't be of much help.  But I'll look around and see what I can find for ya.
0
 
LVL 8

Accepted Solution

by:
dds110 earned 100 total points
ID: 10998038
example of creating a database with sql server and vb
http://doc.ddart.net/mssql/sql2000/html/sqldmo/dmoref_ex01_0bs5.htm

checking the users permissions within sql server (article from http://www.winnetmag.com/SQLServer/Article/ArticleID/20176/20176.html)

***********************************************************************
How do I get the current user’s effective permissions?

If you want to check whether the current user has a certain statement, object, or column permission, you can use the PERMISSIONS() function. The PERMISSIONS() function gives you the effective permissions that result from NT groups, server roles, and the user’s database role membership as well as explicit permissions granted to that user.

You can invoke the PERMISSIONS() function with no arguments to check statement permissions, with an object ID to check object permissions, or with both an object ID and a column name to check column permissions. The function returns an integer with a bitmap that contains the effective permissions. SQL Server Books Online (BOL) provides a detailed explanation about how to use this function and which bits represent which permissions. Listing 5 contains a few examples that demonstrate how to use the PERMISSIONS() function.

***********************************************************************

You can use the ListDatabasePermissions Method of the user object (all done through sql-dmo) to enumerate the users permissions.  See this link for more info (it's in C, but I think you can manage).

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_ob_u_31v8.asp
0
 
LVL 8

Expert Comment

by:dds110
ID: 11014808
hello?
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question