Sécurité SQL 2008 -- Mise en place de la sécurité sur le profiler ...

Vous êtes ici : Accueil > Tutoriaux

Publié le : 02/06/2011 vers 20h
Mise à jour le : 29/10/2010 vers 13h
Catégories :
  • SQL Server

Auteur(s) :
Thierry VINCENT (Membre depuis le 30/03/2010)
Société : Arthsoft
Fonction : Dirigeant
Contactez cet auteur - Affichez les ressources de cet auteur

Comment mettre en place de la sécurité que pour le profiler d'SQL Serveur 2008 ...

Procédure de mise en place :

  1. Lancer SSMS.
  2. Connectez-vous sous votre instance SQL.

     
     
  3. Développer le noeud de la sécurité SQL Serveur.


     
     
  4. Création de votre "Login" SQL.
     
     
     
  5. Sélection dans la page de sélection sur votre gauche, les "Rôles de serveur".


  6. Avoir que la case à cocher "Public".
     
  7. Sélection dans la page de sélection "Mapping Utilisateurs".


     
  8. Cocher pour exemple une de vos bases de données utilisateurs.
  9. Par défaut, le schéma sera "dbo" Si rien n'est saisi dans la dernière cellule "Schéma par défaut".
  10. Sélection dans la page de sélection "Sécurisables". 
     

     
  11. Cliquez sur le bouton "Recherche" de sécurisables ... 


     
  12. Sélectionner le bouton "Le serveur [Nom de votre serveur]" ....
  13. Cliquez sur le bouton "OK"
  14. Vous allez visualiser le nom de votre serveur dans la grille "sécurisables".
  15. Vous allez rechercher dans "Permission" (en dessous), dans ce même nom de colonne la phrase "Alter Trace"


     
  16. Aprés l'avoir trouvé et coché vous n'aurez que les droits sur le profiler SQL ...
     

Bonne Lecture
Thierry

Votre commentaire:

Votre pseudo :

Votre commentaire :

Saisir les caractères ci-contre dans le champ suivant :
 Rafraichir

PseudoCommentaire
gordon
31/01/2017 17:34:39
suGDW5 http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
chaba
29/01/2017 14:56:05
hOLuMm http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
matt
29/01/2017 14:55:09
k0tFvz http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
Barnypok
29/12/2016 08:25:03
tRWwQO http://www.FyLitCl7Pf7ojQdDUOLQOuaxTXbj5iNG.com
Barnypok
28/12/2016 14:03:17
dPq4OX http://www.FyLitCl7Pf7ojQdDUOLQOuaxTXbj5iNG.com
JimmiXzS
15/10/2016 04:31:03
8QXjZA http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com
JimmiXzS
15/10/2016 02:20:28
gfvVy8 http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com
JimmiXzS
15/10/2016 02:10:42
JFKUtG http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com
Mark
11/05/2016 18:36:51
IpgRnW http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
Emery
08/10/2015 08:35:29
International directory enquiries buy metronidazole 500mg tablets aq Vale has already done what it had to do to build and startup the mill, commonly known as CSA, with German steelmakerThyssenKrupp AG, Ferreira told journalists on a phoneconference. The German group is in talks to sell itsmoney-losing Steel Americas division, which includes CSA and aplant in Alabama. Potential bidders include Cia SiderurgicaNacional SA, a Vale rival in the iron-ore miningbusiness.
Morris
08/10/2015 08:35:28
I can't get through at the moment voltaren 75mg lk One Syrian refugee who had crossed into Iraq said he believed “there is no more hope of a peaceful solution in Syria”. He explained that they were being “bombed by the regime and members of the al-Nusra Front were blowing themselves up”. He said that “the Kurds and Arabs were fleeing the country”.
Modesto
08/10/2015 08:35:27
I'd like to change some money propecia costco pharmacy tm Japan spiralled into deep recession after the sales tax wasincreased in 1997 to 5 percent from 3 percent. Economists aredivided on how much the hike was to blame, as the Asianfinancial crisis and then Japan's own banking crisis followedshortly afterwards.
Ethan
08/10/2015 08:35:26
I didn't go to university order finasteride canada nu The trial is expected to extend at least into next week. Rhodes has scheduled 10 days of hearings over three weeks. He likely will not rule whether the city was eligible to file for bankruptcy until at least mid-November.
Christoper
08/10/2015 08:35:25
How many days will it take for the cheque to clear? cheap misoprostol online ww Celesio Chief Executive Marion Helmes has said that an alliance or tie-up with a U.S. partner could help win steeper discounts, mainly for the generic drugs it buys but also for non-prescription medication and skin care products.
Guadalupe
08/10/2015 08:35:24
What sort of music do you like? generic propecia price walgreens ip Forty per cent of his time, he thought, would be spent on his new media commitments; 40 per cent on running the management agency which guides the careers of young players; and 20 per cent for his own delectation, including the racing “hobby” which has become more like a magnificent obsession.
Bobbie
08/10/2015 08:35:23
Sorry, I'm busy at the moment voltaren gel 1 gi And it is bound to get hotter, given Democrat Bill de Blasio’s promise of a moratorium on co-locations and Republican Joe Lhota’s appearance this week at a protest organized by charter school advocates.
Sofia
08/10/2015 08:35:22
What qualifications have you got? what is diclofenac rv Omidyar, the 46-year-old French-born Iranian-American whoremains chairman of the e-commerce giant he founded, wrote in ablog post that he considered buying the Washington Post - whichAmazon.com Inc founder Jeff Bezos eventually snapped up- but decided he wanted to build a news organization from theground up.
John
08/10/2015 08:35:21
I'm a member of a gym purchase zoloft canada np The infant and mother were both taken to Jersey City Medical Center. Roque said the bus driver was also transported to the hospital, where he was under close supervision and would undergo routine tests for alcohol and drugs.
Buford
08/10/2015 08:35:20
I'm sorry, I'm not interested cost of cytotec ve The problem behind the financial issues of Detroit has been a flight of capital to the suburban areas, he said. We have to bring foot traffic and investment back to Detroit. This is exactly what it needs.
Roland
08/10/2015 08:30:26
What university do you go to? asks admirable how to get off zoloft 50 mg registered dusty I was really surprised to get pole, Hamilton said. I was expecting Sebastian to get it and it didn't even feel that great a lap. We've brought some upgrades this weekend and the guys have been working incredibly hard.
Nos partenaires : www.bestof-microsoft.com | www.exchangedump.com | www.exchangedump.com | www.formation-exchange.com | www.formation-management-dif.com | www.formation-mcpd.com | www.formation-pmp.com | www.formation-seven.com | www.formation-windows-7.com | www.formation-windows7.com | www.formation-windows-seven.com | www.certification-mcpd.com | www.certification-windows-7.com | www.consulting-exchange.com | www.e-managementinstitute.org | www.certification-mcitp.com | www.formation-mcsa.com | www.bestof-exchange.com | www.exchange-consulting.com | www.bestof-voip.com | www.formation-cisco.com www.formation-mcitp.com.com | www.laboratoire-exchange.com | www.messagerie-consultant.com | www.bestof-windows.com | www.bestof-sharepoint.com | www.messagerie-consultants.com | www.formation-mcts.com | www.consultant-messagerie.com