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  




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