August 12, 2008 at 9:33 am
Hi all,
I have a new database restored on my sql server, but I need to create a login with a user that will have full database access rights on the database, can anyone show me a script to achieve this,
What kind of access defines full databases access?
Thanks
August 12, 2008 at 10:04 am
"Full" database access is open to interpretation, so I guess you'll have to define it. I generally figure a database user i.e. a customer needs to read, update, insert, and delete data, while a developer needs those permissions plus the ability to create objects in the database such as tables, views, stored procedures, and user-defined functions.
Greg
August 12, 2008 at 10:09 am
I am a DBA, actually setting up a test environment, so I have installed the server, restored a database, created a user and login for it, will be doing various tasks on the database/server from the perspective of a DBA, so I think I require high level rights.
Thanks
August 12, 2008 at 10:39 am
Since you're the DBA, are you a member of the sysadmin server role? If so, you'll be able to do anything in any database without explicitly creating a user for yourself in the databases.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply