BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-27-2008, 09:13 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2007
Location: London
Model: 8310
Carrier: O2 UK
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Utterly confused with SQL permissions

Please Login to Remove!

All,

I'm managing to confuse the hell out of myself with SQL permissions and role-based administration. Can anyone give me a quick summary of the permissions needed, on SQL, for the following types of users? ::

1) The main BES admin login;
2) Members of a DL which will be given the "rim_db_admin_security" role;
3) Members of a DL which wil be given the "rim_db_admin_sr_helpdesk" role;

Our DBA is very keen to minimise the number of people with sa permissions, but I have no idea which people /need/ sa in the first place!

It's a minefield out there..

Cheers

Richard
Offline  
Old 06-27-2008, 09:54 AM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
1) The main BES admin login;
sysadmin role

Quote:
2) Members of a DL which will be given the "rim_db_admin_security" role;
rim_db_admin_security role

Quote:
3) Members of a DL which wil be given the "rim_db_admin_sr_helpdesk" role;
rim_db_admin_sr_helpdesk role
Offline  
Old 06-29-2008, 01:01 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2007
Location: London
Model: 8310
Carrier: O2 UK
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Hdawg.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

INTERLAKE Poly Strapping Coil White Core Machine, 220 White, Small 1/4" / 7.375
$65.0
INTERLAKE Poly Strapping Coil White Core Machine, 220 White, Small 1/4 Square D 8536SEG1V02AS NEMA3 Mag Starter 110-120 volt coil
$500.0
 Square D 8536SEG1V02AS NEMA3 Mag Starter 110-120 volt coil pictureSQUARE D MOTOR STARTER NEMA 3 600volt 110 VOLT COIL
$750.0
SQUARE D MOTOR STARTER NEMA 3 600volt  110 VOLT COIL pictureAllen Bradley 500-A0B94 Size 0 Motor Starter 500A0B94 460-480 VAC Coil AOB94
$264.99
Allen Bradley 500-A0B94 Size 0 Motor Starter 500A0B94 460-480 VAC Coil AOB94  pictureAllen Bradley 100-C09Q10 12 VAC Coil 9 Amp Starter 100C09Q10 100-C09 New
$69.99
Allen Bradley 100-C09Q10 12 VAC Coil 9 Amp Starter 100C09Q10 100-C09 New picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.