Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Marketware
Starting Member
9 Posts |
 Posted - 2010-04-16 : 12:11:30
|
| What is the best way to determine if a specific login has the privileges to create a database from a backup?I want to perform a test to see if a login can do the task.bob |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-04-16 : 12:24:35
|
| He should be member of db_creator role. |
 |
|
|
Marketware
Starting Member
9 Posts |
Posted - 2010-04-16 : 12:34:43
|
| Is there an t-sql query that can tell me if he is a member? Also, if a login say "sa" is used and it is part of db_admin, would the same query tell us that it is a member of that group because db_admin effectively has the same rights?Thanks in advance.bob |
|
|
|
|
|
|
Determine if Login has permission to do...