Tool for User Administration for Level 1

Question

Tool for User Administration for Level 1

sehgalnamit

SSC Eights!

Points: 813
More actions
July 31, 2013 at 12:16 am

#395230

Can you suggest me a tool for User administration like create user, assgn roles, permmissions for sql server.
My goal is to assign these activites to my level 1 team who knows nothing at sql server.
SQL Managemenet Studio I donot want to provide.

Viewing 10 posts - 1 through 9 (of 9 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

sehgalnamit (7/31/2013)
Can you suggest me a tool for User administration like create user, assgn roles, permmissions for sql server.
My goal is to assign these activites to my level 1 team who knows nothing at sql server.
SQL Managemenet Studio I donot want to provide.

If they know nothing about SQL Server, then why allow them to perform a fairly critical task such as security?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sehgalnamit SSC Eights! Points: 813 More actions · Answer 2

Actually that is a good question. But we have a standard template for user permmissions request which they can follow wasily. We just need a tool which is easy to operate for such tasks.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

The tool to use would be SSMS

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sehgalnamit SSC Eights! Points: 813 More actions · Answer 4

SSMS is what I do not want to give.

I need a simple tool like ARS for AD for USer creation etc...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

You could teach them how to do it via SQLCMD or PoSH.

As far as a GUI tool, I don't recommend anything other than SSMS for User Administration.

If you have a query interface, you can teach them how to do it via script.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

tonyf SSC Veteran Points: 264 More actions · Answer 6

Idera's SQL admin toolset has two tools that may help you:

SQL Login Copy

Copy server logins across SQL Servers

SQL User Clone

Create a new user using an existing user as a template

Plus 22 other useful tools

see: http://www.idera.com/productssolutions/sqlserver/sqladmintoolset

tim_harkin SSCrazy Points: 2399 More actions · Answer 7

Create the proper access in SQL using AD user groups. The the level 1 team can add and remove users from the AD groups as needed.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

tim_harkin (7/31/2013)
Create the proper access in SQL using AD user groups. The the level 1 team can add and remove users from the AD groups as needed.

Very good solution.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

tim_harkin SSCrazy Points: 2399 More actions · Answer 9

SQLRNNR (7/31/2013)
tim_harkin (7/31/2013)
Create the proper access in SQL using AD user groups. The the level 1 team can add and remove users from the AD groups as needed.
Very good solution.

Thanks, SQLRNNR