Urgent
-
Dear All, How do i set the Database object security from the frontend for the SQLServer with User Interface Like If you create new login , What are all the privilege i need to give to that user I m going to do this using Front End using C# with SQLServer. With GreatRegards, Siva
-
Dear All, How do i set the Database object security from the frontend for the SQLServer with User Interface Like If you create new login , What are all the privilege i need to give to that user I m going to do this using Front End using C# with SQLServer. With GreatRegards, Siva
Shiv5 wrote:
Urgent
Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?
Shiv5 wrote:
How do i set the Database object security from the frontend for the SQLServer with User Interface
What do you mean by your use of the proper noun "User Interface"? Do you mean using Enterprise Manager? Or did you mean "user interface" (adjective + noun combination)?
Shiv5 wrote:
Like If you create new login , What are all the privilege i need to give to that user
What do you want the user to be able to do? What do you want them not to be able to do?
Shiv5 wrote:
I m going to do this using Front End using C# with SQLServer
What is this proper noun "Front End"? Is it a new IDE? I'm gussing you mean you want to write a program in C# that will create a new user and assign privileges to that user. Is that correct? You can run just about any SQL code through a
SqlCommandobject. If you can write in in Query Analyzer you can run it through aSqlCommandobject (Just remember every time you see aGOin query analyzer that is newSqlCommand. The SQL commands that you need are likely to be: * sp_grantlogin[^] * sp_grantdbaccess[^] * GRANT {SELECT / UPDATE / INSERT / DELETE / EXECUTE} ON {object} ON{security account}[^]
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the
-
Shiv5 wrote:
Urgent
Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?
Shiv5 wrote:
How do i set the Database object security from the frontend for the SQLServer with User Interface
What do you mean by your use of the proper noun "User Interface"? Do you mean using Enterprise Manager? Or did you mean "user interface" (adjective + noun combination)?
Shiv5 wrote:
Like If you create new login , What are all the privilege i need to give to that user
What do you want the user to be able to do? What do you want them not to be able to do?
Shiv5 wrote:
I m going to do this using Front End using C# with SQLServer
What is this proper noun "Front End"? Is it a new IDE? I'm gussing you mean you want to write a program in C# that will create a new user and assign privileges to that user. Is that correct? You can run just about any SQL code through a
SqlCommandobject. If you can write in in Query Analyzer you can run it through aSqlCommandobject (Just remember every time you see aGOin query analyzer that is newSqlCommand. The SQL commands that you need are likely to be: * sp_grantlogin[^] * sp_grantdbaccess[^] * GRANT {SELECT / UPDATE / INSERT / DELETE / EXECUTE} ON {object} ON{security account}[^]
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the