Login to provide with Database creation and Import rights

Question

Login to provide with Database creation and Import rights

mail.baberkhan

SSC Rookie

Points: 25
More actions
February 27, 2012 at 7:19 am

#269208

With DB creator can provide access to create the database but what about to provide access to give the import rights can please any one suggest on it
Thanks

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

sengeet86 Ten Centuries Points: 1252 More actions · Answer 1

mail.baberkhan (2/27/2012)
With DB creator can provide access to create the database but what about to provide access to give the import rights can please any one suggest on it
Thanks

You must have read permissions to access the database from which you import the objects .

java programming

mail.baberkhan SSC Rookie Points: 25 More actions · Answer 2

BULKADMIN

BULK INSERT administrators. Can load data into tables using BULK INSERT statement.

Database administrators responsible only for loading data through BULK INSERT. Data import specialists.

So With Bulk Admin rights can import data so by providing

DBcreator and bulk Admin can provide the user with DB creation and Import rights ??

Lowell SSC Guru Points: 323546 More actions · Answer 3

mail.baberkhan (2/28/2012)
BULKADMIN
BULK INSERT administrators. Can load data into tables using BULK INSERT statement.
Database administrators responsible only for loading data through BULK INSERT. Data import specialists.
So With Bulk Admin rights can import data so by providing
DBcreator and bulk Admin can provide the user with DB creation and Import rights ??

well, with dbCreator rights, any database they create , they will be the owner, and have dbo rights....so they can do anything to those new databases.

BULK ADMIN gives the login rights to use the BULK INSERT command (that does NOT mean buldk insert into any old table!), so unless additional permissions (SELECT/INSERT/UPDATE/DELETE) are given to the other databases objects , that login would not be able to insert any data into other databases.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mail.baberkhan SSC Rookie Points: 25 More actions · Answer 4

Hi Thanks ,

for update but my my requirement for client is to provide the user with DB creation & Import rights

DB creation is ok but I want to assing the User with Import rights so what privilages should i give

Can you please update me .

IS bulk admin role works for import rights ??

Lowell SSC Guru Points: 323546 More actions · Answer 5

Import rights = which database?

you have to define that a lot better;

if this is for one existing database, you need to add the login as a user to that database, and probably give db_datareader and db_datawriter.

for multiple databases to have "Import rights", then you have to repeat that procedure...add the login as a user, and assign the roles that is appropriate for the job .

any role at the server level is going to give a lot more rights than is probably necessary.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mail.baberkhan SSC Rookie Points: 25 More actions · Answer 6

Hi the user xyz should need access to create the new database (dbcreator) and have the rights to import from flat files for newly created database ..

So should it will work to provide the logins with the dbcreator role and bulk admin role ??